Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
Looking for a way to apply a MTD or YTD filter to the entire page without having to rewrite all the measures (and many of these are nested
Have two columns in the DateTable with formulas for either MTD or YTD and want to use these to create a chiclet of MTD or YTD.
All the solution for this problem so far are diconnected tables with custom measures based on what is selected.
Ideas?
Solved! Go to Solution.
Hi @ThreeBlindMice ,
I'd like to suggest you create a dynamic attribute filter or add a selector table as the source of the slicer, then you can use its selection and 'switch' function to change calculate results based on the slicer.
Dynamic Attributes In A Power BI Report
Power BI – Using a Slicer to show different measures
Regards,
Xiaoxin Sheng
Hi @ThreeBlindMice ,
I'd like to suggest you create a dynamic attribute filter or add a selector table as the source of the slicer, then you can use its selection and 'switch' function to change calculate results based on the slicer.
Dynamic Attributes In A Power BI Report
Power BI – Using a Slicer to show different measures
Regards,
Xiaoxin Sheng
Hi
Thanks for that suggestion.
I've rebuilt my date table to be more dynamic (so that it outputs columns of 'MTD' and 'YTD') and the unpivot within PBI. An attribute table and a couple of links and it seems to work.
Now just have to check the results.
Relative date filter filtering
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
You can have in slicer or in Page level parameter pane
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |