Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am putting together a metrics report and I am having some issues with dates. I have 5 visuals that I want to display the data between certain dates, but the 6th visual I only want to display the data for the last date that is selected. For example:
The user wants to see data for the range of January through July. I want 5 visuals to show all numbers for that range, and the 6th I only want to display July data.
Is this something that is possible? Also I apologize, I cannot share my .pbix file as it contains sensitive data.
Thank you in advance!
Solved! Go to Solution.
Hi @NJ81858 ,
Yes, it's possible.
You need a calendar table. You can create it using DAX.
Calendar = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))
Modify the two measures.
Measure = IF(MAX('Table'[Date])>=MIN('Calendar'[Date])&&MAX('Table'[Date])<=MAX('Calendar'[Date]),1)
Measure 2 = IF(MONTH(MAX('Table'[Date]))=MONTH(MAX('Calendar'[Date])),1)
Based on the previous solution1, add a slicer of a calendar table to filter the date range.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @NJ81858 ,
Solution 1:
You can use the filters to filter. In addition to fields that can be added to filter, measures can also be added.
Measure = IF(MAX('Table'[Date])>=DATE(2022,1,1)&&MAX('Table'[Date])<=DATE(2022,7,31),1)
After you add the measure into the visual-level filter, and set up show items when the value is 1, you'll see data for the range of January through July. And this is the visual 1. The other four visuals can also be set up like this.
About the visual 6, you can create another visual below and add it into the visual-level filter of visual 6.
Measure 2 = IF(MONTH(MAX('Table'[Date]))=7,1)
Solution 2:
You can change the interaction of the visuals. You can learn about it from the following document:
Change how visuals interact in a report - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-stephen-msft is there a way to make the first solution dynamic? So that is the user wants to see different months then the visual that shows the last month will change as well?
Hi @NJ81858 ,
Yes, it's possible.
You need a calendar table. You can create it using DAX.
Calendar = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))
Modify the two measures.
Measure = IF(MAX('Table'[Date])>=MIN('Calendar'[Date])&&MAX('Table'[Date])<=MAX('Calendar'[Date]),1)
Measure 2 = IF(MONTH(MAX('Table'[Date]))=MONTH(MAX('Calendar'[Date])),1)
Based on the previous solution1, add a slicer of a calendar table to filter the date range.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
86 | |
83 | |
67 | |
61 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
84 | |
70 |