Dynamic Chart Title as per last Drill down / filter

[Riteshheda]

Hi All Genuises,

I want to create a dynamic chart title based on current drill-down level/filter and should reflect value from that certain column.

Example: I have a 5 level drill-down, A->B->C->D->E. Tried to use a measure but getting all filter values in chart title. 

On drill-down to "C", I want "Sales for C" and not as "Sales for A->B->C"

if its for D, then "Sales for D"

Query: Measure to return current filter / drill-down value on entire page.

Thanks

[Riteshheda · Accepted solution]

I am using below code for Dynamic Chart Title

ChartTitle =

var SBU_name = SELECTEDVALUE(SBU[SBU],"All SBUs") & ""

var Mth = if(

ISFILTERED('Calendar'[Month]),

SELECTEDVALUE('Calendar'[Month]) & "> ",

"")

var Dist_Chnl = if(

ISFILTERED(ZFND_New[DC]),

"> " & SELECTEDVALUE(ZFND_New[DC]),

"")

var Div_name = if(

ISFILTERED(Division[Sales Office]),

"> " & SELECTEDVALUE(Division[Sales Office]),

"")

var RG_name = if(

ISFILTERED(Region[Region-Group]),

"> " & SELECTEDVALUE(Region[Region-Group]),

"")

var SG_name = if(

ISFILTERED('Sales Group'[SG Description]),

"> " & SELECTEDVALUE('Sales Group'[SG Description]),

"")

var SD_name = if(

ISFILTERED(ZFND_New[District name]),

"> " & SELECTEDVALUE(ZFND_New[District name]),

"")

return

"Net O/s. for " & Mth & SBU_name & Dist_Chnl & Div_name & RG_name & SG_name & SD_name

[v-xulin-mstf]

Hi @Riteshheda,

You can refer this to achieve Dynamic Chart Title.

The sample works well.

Best Regards,

Link

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

[v-xulin-mstf]

Hi @Riteshheda,

Maybe Drill Pathways can meet your needs, please refer: Drill pathways

Best Regards,

Link

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

[Riteshheda]

Thanks for reply, but not looking for drill solution. I want Dynamic Chart Title based on selected drill level.

Example: I have a 5 level drill-down, A->B->C->D->E. Tried to use a measure but getting all filter values in chart title. 

On drill-down to "C", I want Chart Title as "Sales for C" and not as "Sales for A & B & C"

On drill-down to "D", I want Chart Title as "Sales for D" and not as "Sales for A & B & C & D"

[lbendlin]

Try disabling the "Keep all filters"  option