Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
edubcardoso
Advocate I
Advocate I

Just show the right tooltip, depending on the year

Hello everyone !

I create a line and clustered column chart where the dark colors (dark blue and red) are this year's values and the light colors(light blue and yellow) are last year's values.

e9944f4a-26d0-470b-9b10-cd64668e0538.png

I created a tooltip to show the value of the rows when I select a column, but it shows me the tooltip for the both years (example below)

print2.png (tooltip for set this year)

 

print1.png (tooltip for set last year)

I wanted the tooltip to only show one of the profits, depending on the year.

In the first image only revenue.

In the second, only revenue lastyear

 

Is there any way to do this ?

 

Thanks for the help.

1 ACCEPTED SOLUTION

@edubcardoso I have a presentation for Enterprise DNA coming out soon on Dueling Tooltips. I've attached the PBIX file for you below my signature. This might give you some ideas. 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@edubcardoso You could create a Tooltip page to display only the information you want to display.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler 

Thank you for answering, mate!

I just found out about that just now, but I don't know how It would go from this year's measure to the previous year's measure.


Maybe using an IF( statement ,[Sum],[Sum LastYear]), but which statement should I use ?

 

(Sorry for the bad English, but it was translated by DeepL)

 

 

@edubcardoso I have a presentation for Enterprise DNA coming out soon on Dueling Tooltips. I've attached the PBIX file for you below my signature. This might give you some ideas. 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors