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, I need some help from the community.
I have a tooltip with two visuals, a card that brings status information (if any) and another with a line chart with month-to-month values.
What I would like the year filter to be kept, but the month filter should only work for the card and the line chart would ignore this filter to always bring month-to-month information in this tooltip. But, as it is, this visual ends up being filtered too and I can only see the information for the selected month.
Is there any way to get around this situation?
What I have:
What I expect (the image below was edited, I can't get this result):
Link to the sample report: https://1drv.ms/u/s!At5JlMR_naI1gf40U3c-hDE-XSNLgw?e=8Ou6oh
Thank you!
Solved! Go to Solution.
I believe I got it to do what you are looking for.
The only way I could think to do it was to have a copy of the calendar table and use the month name from the second table in the chart for the tooltip. This combined with a measure for the amonut that removes the filter from the primary calendar table seems to do the trick.
Total All Months = CALCULATE ( [Total], ALLEXCEPT( 'calendar', 'calendar'[Year] ) )
I have attached my updated file for you to look at.
I believe I got it to do what you are looking for.
The only way I could think to do it was to have a copy of the calendar table and use the month name from the second table in the chart for the tooltip. This combined with a measure for the amonut that removes the filter from the primary calendar table seems to do the trick.
Total All Months = CALCULATE ( [Total], ALLEXCEPT( 'calendar', 'calendar'[Year] ) )
I have attached my updated file for you to look at.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |