cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Microsoft v-yulgu-msft
Microsoft

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

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
Super User IV
Super User IV

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

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


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

Not the Power BI thought police...

I have 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 Datanaut!

Microsoft v-yulgu-msft
Microsoft

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

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

dvhez Helper II
Helper II

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

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

 

 

 

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors