Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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...
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
85 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
97 | |
71 | |
67 |