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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply

Dynamic Date measure for custom tooltip when Drilling up or Expanding

I am creating a custom tooltip for a line chart. Users can Drill up or Expand to the next level in the date hierarchy (Year - Quarter - Month). 

In the tooltip, I'd like to write a measure to display the Year only when viewing on 'year' level, Year and Quarter only when viewing on 'quarter' level , Year and Quarter and Month name on 'month' level. Or any other alternatives. Currently I'm placing textboxes "Year","Quarter","Month" next to respective card visuals (using SELECTEDVALUE()); but a. it's difficult to align them nicely and b. when you're on the 'year' level, the quarter and month cards are blanks, while the texts "Quarter" & "Month" are still there. 

 

1 REPLY 1
Mariusz
Community Champion
Community Champion

Hi @phuonganhtdinh 

 

Can you post some examples?

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.