Video by: Reid Havens
Learn how to add various KPI indicators to the native visuals (Line, Area, etc.) in Power BI using a bit of DAX magic.
Adding KPI Indicators to Native Line Charts in Power BI
Posts filed under Power BI
Relationship Issues With DateTime Data Types in Power BI
Video by: Reid Havens
Learn about a potential pain point when it comes to dealing with DateTime data in a fact table. You can potentially encounter an issue when joining your fact to a calendar table. Specifically if you import a Fact table into your model with a datetime column, and convert that column to a date data type in the model, instead of in Power Query. If you do this then that relationship still won't work until you make that change in Power Query.
RELATED CONTENT 🔗
(Livestream Replay) Power BI Sidetools External Tool - Didier Terrien
Come hang out as Didier Terrien and I talk about (Power BI Sidetools). Power BI Sidetools is an innovative external tool offering unique features to improve productivity when developing reports, with an impressive list of features and tools contained within! Features such as: exporting data to Excel, transferring DAX and M formulas to files, viewing DAX and M code in Visual Studio Code, preview DAX measures in auto-generated tables, and more!
DIDIER’S BIO 📄
I worked with data for almost 4 decades in various environments as a developer and project manager. Heavy user of Excel for a long time, I try to move data as much as possible to Power BI since it appeared on the market. Working now as the Group Data Quality Officer in Trescal, my skills cover business and IT areas for the benefit of productivity and quality.
RELATED CONTENT 🔗
Didier's Website
Sidetools Site
Sidetools Support
Didier's Linkedin
Didier's Twitter
Fiscal Periods Time Intelligence Slicer in Power BI
Video by: Reid Havens
Part four of four in a series - learn how to leverage relationships and DAX calculated tables to create a time intelligence slicer with fiscal periods in Power BI. The end result will perform faster and create a better user experience versus needing to create many time intelligence DAX measures.
RELATED CONTENT 🔗
Part 1: Creating MTD/QTD/YTD Filters
Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periods
