In this video, Patrick shows how you can fix quick measures that break when you use dates with time calculations. Patrick referenced a blog from Kasper de Jong. You can find that here: Use the Power BI quick calcs with your own date table
Use Multiple Connections Between Tables (@PowerBITips) The ALL() Function in DAX (@ExceleratorBI) Responsive visualizations coming to Power BI Power BI Desktop July Feature Summary Power BI Service and Mobile June Feature Summary BONUS ITEMS: Data Privacy Settings In Power BI/Power Query, Part 4: Disabling Data Privacy Checks (@Technitrain) Integrate Power BI into Your Application: Part [...]
In this video, Patrick shows why you may hit some issues with time calculations and how to fix time. He typically sees this when using a Data Warehouse.
In this video, Patrick shows how you can display multiple values within a tooltip for a visual. He walks through the DAX measure and also shows some pitfalls to look out for when it comes to filter context. DAX Sample Statement: Color Tooltip = var itemcount = DISTINCTCOUNT(StockItem[Color]) return IF(itemcount > 3, CONCATENATEX(TOPN(3,VALUES(StockItem[Color])),StockItem[Color],",")&" and more...", [...]
The DAX Unichar() Function And How To Use It In Measures For Data Visualisation (@technitrain) ArcGIS Map in Power BI; Simple, But Insightful (@Rad_Reza) Create Column From Examples (@kpuls) Power BI Quick Measures is a Game Changer (@Paul_Turley) Get ready for the new Power BI navigation experience BONUS ITEMS: New Reports From Existing Datasets (@ExceleratorBI) [...]
DAX Time Intelligence for Beginners (@ExceleratorBI) Defining the Components of a Modern Data Warehouse (@sqlchick) Publish Power BI Reports to SSRS On-premise Preview Now Available (@Paul_Turley) Help Improve DirectQuery! Introducing email subscriptions in Power BI: stay informed when it matters BONUS: Compare equivalent periods in DAX (@marcorus) Seven Steps for Using Data and Power BI [...]
Chris Webb looks at how to use Value.ResourceExpression() to see how Query Folding is working. Marco Russo looks at how to leverage INTERSECT. We look at a post geared towards consultants and how they can leverage Shared Dashboards in their work. Also, there was a special day last sunday and we recap that. Value.ResourceExpression() And [...]
Catching up on the last two week. We had a big post regarding updates to the Power BI service. This included exporting data from a tile or report, adding images and textboxes, printing, connecting to SharePoint, pinning Excel charts, Power BI in Brazil and Hebrew/Arabic LTR support. I also look at some great posts from [...]