Dynamic Title Change based on Selection of 3 Columns and Dates Between..

[krrish116]

Hi @amitchandak ,

Based on your Previous answer for a Query, i have to add extra Dynamic Title Change 

Old Question :

I had a table with 4 columns  

  Date                 Site           Sceneario      Position

20-02-2021         CP             Referral           80

22-02-2021         OP             Gifferal            75

01-03-2021         GP             Referral            24

02-03-2021         QP            Coferral             43

We are showing data in 2 graphs

in first graph

Im showing 

Date on Axis

Scenario on Legend

Position on Values

in Second graph

Im showing

Site on Shared Axis 

Position on Column Values...

Answer from You:

@krrish116 , is filtered should help

Assume MTD using the Date table

All measures below

measure = SUM(Table[position])

MTD = CALCULATE([measure],DATESMTD('Date'[Date]))

if(isfiltered(Date[Date]), [measure],[MTD]).

It is working fine and fantastic..

Now for the chart i have to create a dynamic title based on
Selection of Date Slicer (Between Dates like 02/01/2020    03/08/2021) and for that
date i have created two calculated columns

1. Month-Year = DATE(YEAR([DATE]), MONTH([DATE]),01)

2. Qrtr-Year = YEAR('Inspection InspectionPerformanceKPI'[AddedOn]) & " Q"

& ROUNDUP(MONTH('Inspection InspectionPerformanceKPI'[AddedOn])/3, 0)

SO if we select the Qrtr-Year or Month-Year or else the DATE Slicer (Between Dates like 02/01/2020    03/08/2021)

The Title has to change Dynamically..

By Default the title is Current Month By Site,

If we select any Month-Year then Feb-20 By Site, (Based on Selection)

If we select any Qrtr-Year  then 2020Q1 By Site, (Based on Selection)

If we Select any dates in Date Slicer then  02/01/2000 -- 03/08/2021. (Based on Selection)

Please help me in sorting out this..

Thanks,

Krish..

[Icey · Accepted solution]

Hi @krrish116 ,

Try to put the below measure into "Format" -> "Title" -> "fx".

Title =
SWITCH (
    TRUE (),
    ISFILTERED ( 'YourTable'[Month-Year] ), SELECTEDVALUE ( 'YourTable'[Month-Year] ) & "By Site",
    ISFILTERED ( 'YourTable'[Qrtr-Year] ), SELECTEDVALUE ( 'YourTable'[Qrtr-Year] ) & "By Site",
    ISFILTERED ( 'YourTable'[Date] ), SELECTEDVALUE ( 'YourTable'[Date] ) & "By Site"
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Icey · Accepted solution]

Hi @krrish116 ,

Try to put the below measure into "Format" -> "Title" -> "fx".

Title =
SWITCH (
    TRUE (),
    ISFILTERED ( 'YourTable'[Month-Year] ), SELECTEDVALUE ( 'YourTable'[Month-Year] ) & "By Site",
    ISFILTERED ( 'YourTable'[Qrtr-Year] ), SELECTEDVALUE ( 'YourTable'[Qrtr-Year] ) & "By Site",
    ISFILTERED ( 'YourTable'[Date] ), SELECTEDVALUE ( 'YourTable'[Date] ) & "By Site"
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[krrish116 · Accepted solution]

Hi @Icey 
Thanks for the Solution and even i tried another measure ..

Site Title =
"Site Value By " & SELECTEDVALUE('Table'[Month-Year],

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

" " & SELECTEDVALUE('Table'[Qrtr-Year] , "Current Month")) )

Thanks fro the help once again.

Thanks,

Krish..

[amitchandak]

@krrish116 , Can you share a screenshot, what does means by selection Month Year, Qtr year. based on that I can suggest