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.
For the following chart, I included two cards in order to show both filter's name. I know that maybe this isn't what cards are for, but it's useful for my porpuses. However, if there's no year/month selected, it will show the first (or last) of the one which isn't selected. Is there an alternative way to achieve this? I wan't the user to be able to read from the chart itself the month and year in question. If you have a better apporach, it would be great!
Solved! Go to Solution.
Hi @dvhez,
Maybe you can try this measure:
SelectedItem= IF ( ISFILTERED ( 'Table'[Year] ), SELECTEDVALUE ( 'Table'[Year] ), "No value is selected" )
Best regards,
Yuliana Gu
Hi @dvhez,
Maybe you can try this measure:
SelectedItem= IF ( ISFILTERED ( 'Table'[Year] ), SELECTEDVALUE ( 'Table'[Year] ), "No value is selected" )
Best regards,
Yuliana Gu
Hi @v-yulgu-msft,
Thanks for your answer!. Do you know why it could be that this solution is showing me (Blank) instead of "SEN"?.
ZoneSelect = IF( ISFILTERED ('Capacidad Instalada 2018'[Zone]); SELECTEDVALUE('Capacidad Instalada 2018'[Zone]); "SEN" )
No, this is pretty much how I do it. Take a look at this quick measure I created for dynamic titles, might give you some ideas. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...
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 | |
100 | |
86 | |
64 |