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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
jlaroo33
Frequent Visitor

Dynamic Title with Time Hierarchy

Hello!

 

I am working on creating a dynamic title for a card that summarizes the total number of hires in a certain time period, based on where the user is drilled into a related bar graph. I found the following DAX that gets me close, but I'm not wanting to concantenate the results. For example, if they are drilled into 2022 > Quarter 1 > April, I want the header to read "April". Is this possible? Here's what I'm working with:

 

Selected Value =

SELECTEDVALUE('Date Table'[Date].[Year])&" "&

SELECTEDVALUE('Date Table'[Date].[Quarter])&" "&

SELECTEDVALUE('Date Table'[Date].[Month])&" "&

SELECTEDVALUE('Date Table'[Date].[Day])

 

Thank you! Jodi

1 ACCEPTED SOLUTION
jlaroo33
Frequent Visitor

@JirkaZ Thank you for the suggestion! I couldn't quite get that to work, but here is what I found in case others come across a similar issue. Please forgive my formatting, I'm new to DAX. 🙂

 

Selected Value =
IF(ISFILTERED('Date Table'[Date].[Month]),""& SELECTEDVALUE('Date Table'[Date].[Month])&" "&SELECTEDVALUE('Date Table'[Date].[Year],", "),
IF(ISFILTERED('Date Table'[Date].[Quarter]),""& SELECTEDVALUE('Date Table'[Date].[Quarter])&" "&SELECTEDVALUE('Date Table'[Date].[Year],", "),
IF(ISFILTERED('Date Table'[Date].[Year]),""& SELECTEDVALUE('Date Table'[Date].[Year],", "),"YTD")))

View solution in original post

2 REPLIES 2
jlaroo33
Frequent Visitor

@JirkaZ Thank you for the suggestion! I couldn't quite get that to work, but here is what I found in case others come across a similar issue. Please forgive my formatting, I'm new to DAX. 🙂

 

Selected Value =
IF(ISFILTERED('Date Table'[Date].[Month]),""& SELECTEDVALUE('Date Table'[Date].[Month])&" "&SELECTEDVALUE('Date Table'[Date].[Year],", "),
IF(ISFILTERED('Date Table'[Date].[Quarter]),""& SELECTEDVALUE('Date Table'[Date].[Quarter])&" "&SELECTEDVALUE('Date Table'[Date].[Year],", "),
IF(ISFILTERED('Date Table'[Date].[Year]),""& SELECTEDVALUE('Date Table'[Date].[Year],", "),"YTD")))
JirkaZ
Solution Specialist
Solution Specialist

I think you'll have to go backwards and check Day, Month, Quarter and Year with HASONEVALUE. 
I'd use SWITCH(TRUE(), ... ) for that.
The first value with one value selected should then be used as title.

 

I hope my logic is correct on this 🙂

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors