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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Himanshu_1306
Helper V
Helper V

Dynamic Title

Hi All,

 

I'm trying to create a dynamic title for my card like below but facing issues. At the moment I've manually used the title but want it to be dynamic.

 

Himanshu_1306_0-1668416943016.png

 

Any help in creating the same would be highly appreciated.

FYI : "Churn Lost" I can use as a text as it will be constant. I want to make FY'23 Q3 part dynamic somehow.

 

I have the below column in my table to work on

 

Himanshu_1306_1-1668417069472.png

 

 

1 ACCEPTED SOLUTION

Thanks for the help.

 

I actually created few measures and got the desired result.

 

CurrentFY = CALCULATE( SELECTEDVALUE( D_DATE[FISCAL_YEAR] ),
                    FILTER( ALL( D_DATE ), D_DATE[Date] = TODAY() ) )
 
Last quarter = ROUNDUP(MONTH(TODAY())/3, 0)-1
 
Result :

 

Himanshu_1306_0-1668430698345.png

 

View solution in original post

5 REPLIES 5
JorgePinho
Solution Sage
Solution Sage

Hello @Himanshu_1306 !

 

Try this:

Measure = "FY'" & RIGHT(MAX('Table'[Fiscal Year]),2) & " Q" & MAX('Table'[FISCAL_QUARTER] & " Churn Lost"

Getting the below error

 

Himanshu_1306_0-1668426869089.png

 

@Jo  ALso the max value will give the max result in my dataset. I want the current fiscal year and last quarter in my card.

 

Last quarter I can derive from the below calculation:

 

D_DATE[CALENDAR_QUARTER] = MAX(D_DATE[CALENDAR_QUARTER])-1)

 

Himanshu_1306_0-1668427798075.png

 

I thought you wanted to make it dynamic according to a slicer. If you used a slicer it would display the selected value on the slicer.

 

If you want to do it according to the system date you have to do a Lookup of the fiscal year using MONTH(TODAY()) and YEAR(TODAY())

 

Thanks for the help.

 

I actually created few measures and got the desired result.

 

CurrentFY = CALCULATE( SELECTEDVALUE( D_DATE[FISCAL_YEAR] ),
                    FILTER( ALL( D_DATE ), D_DATE[Date] = TODAY() ) )
 
Last quarter = ROUNDUP(MONTH(TODAY())/3, 0)-1
 
Result :

 

Himanshu_1306_0-1668430698345.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors