Power BI Insights: Select-all slicers; Adding dates to a table; Refreshing Power Pivot Excel data models
Power BI pros discuss how to make the most of select-all slicers, adding dates to a table, and refreshing Power Pivot Excel data models.
Making the most of select-all slicers
Chris Webb blogged about how to manage select all slicers bound to dynamic M parameters in Power BI. Back in 2020, Webb wrote about multi-select scenarios with dynamic M parameters, but select all support was added by Microsoft since then. He explained that because a slicer with no items selected acts the same as a slicer with all items selected, users need additional logic to make everything work correctly.
Using a DirectQuery table and an Import mode table, he setup an M parameter and then enabled both multi-select and select all. Webb demoed his M code and explained a final filter rows step.
Adding years, months, and days to a table
FREE Membership Required to View Full Content:
Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here
or
login
FREE Membership Required to View Full Content:
Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here