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.
I have spent an hour finding a solution for my problem, but not getting there....
I have my report:
When i choose for example 'Open' from 'Overdue Tickets' Charts, i want to see in table just the value where 'Finish until' date is smaller as today.
When i choose 'Open' from 'Next 7 Days Tickets' Chart, i want to see in the table just value with 'Finish until' date between tomorrow and tomorrow+7 Days.
For the charts i created two measures where i use Filter function to select just the values with the desired date.
But i don't know how to filter the table depending on the date from my Charts.
Any ideas?
Thank a lot
Solved! Go to Solution.
In this scenario, when you click in the Donut, only the category you selected will be applied as fitler on other visuals. So your table visual will only be filtered with "OPEN", it can never determine you click it from the "Overdue" or "Next 7 days" charts. The "Next 7 days" filter only works within your measure.
For your requirement, you should add a column to tag if the date in current row is within "Next 7 days".
Date Range = IF ( ( Table[Finish Until] - TODAY () ) <= 0, "UP TO TODAY", IF ( ( Table[Finish Until] - TODAY () ) > 0 && ( Table[Finish Until] - TODAY () ) <= 7, "NEXT 7 DAYS", "OTHER" ) )
Then you can populate above colum into a slicer to filter the Donut and Table visual.
Regards,,
In this scenario, when you click in the Donut, only the category you selected will be applied as fitler on other visuals. So your table visual will only be filtered with "OPEN", it can never determine you click it from the "Overdue" or "Next 7 days" charts. The "Next 7 days" filter only works within your measure.
For your requirement, you should add a column to tag if the date in current row is within "Next 7 days".
Date Range = IF ( ( Table[Finish Until] - TODAY () ) <= 0, "UP TO TODAY", IF ( ( Table[Finish Until] - TODAY () ) > 0 && ( Table[Finish Until] - TODAY () ) <= 7, "NEXT 7 DAYS", "OTHER" ) )
Then you can populate above colum into a slicer to filter the Donut and Table visual.
Regards,,
Thanks a lot. Your help is very much appreciated!
Any ideas please?
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |