cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dvhez
Helper II
Helper II

Is there a way to include a 'changing title' to a chart?

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!

 

PBIDesktop_2018-10-20_16-42-41.png

 

 

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft
Microsoft

Hi @dvhez,

 

Maybe you can try this measure:

SelectedItem=
IF (
    ISFILTERED ( 'Table'[Year] ),
    SELECTEDVALUE (  'Table'[Year] ),
    "No value is selected"
)


Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yulgu-msft
Microsoft
Microsoft

Hi @dvhez,

 

Maybe you can try this measure:

SelectedItem=
IF (
    ISFILTERED ( 'Table'[Year] ),
    SELECTEDVALUE (  'Table'[Year] ),
    "No value is selected"
)


Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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"
)

PBIDesktop_2018-10-23_13-57-21.png

 

 

 

 

Greg_Deckler
Super User IV
Super User IV

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...


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors