The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
96 | |
80 | |
62 | |
57 |
User | Count |
---|---|
261 | |
120 | |
113 | |
83 | |
71 |