How to do dynamic Title of the table when you're using calculation group

[yakovlol]

Hello Community,

Can you please help me to find a way to do a dynamic tittle for my matrix.

I'm using a calculation group and Have Hours and Percentage - which is dynamically switch between these two values

But now I want to have a dynamic tittle, so when I click on Hours - it should dispaly "Hours" and when I click on Percentage - I want to have word "Percentage"

I've tried SELECTEDVALUE (Calculation_group [Name]] but it didn't work, maybe there are other ideas?

[Nithinr]

May be this one works too

Dynamic Title =
SWITCH (
SELECTEDVALUE ( CalculationGroup[Name] ),
"Hours", "Hours",
"Percentage", "Percentage",
BLANK ()
)

[yakovlol]

Hi @Nithinr unfortunately this approach didn't work, maybe because of calculation within the calculation item

So I have a calculation group with 2 calculation Item fr this two Item's are different calculations for each 

And when i tried this measure and Select % of hours in my slicer - it returns me the actual percent 40% - but not the word "Percent" and i cannot  find out why is that and how to change it

[bhelou]

try this : 

DynamicTitle = IF ( ISFILTERED ( 'Calculation_group'[Name] ), SELECTEDVALUE ( 'Calculation_group'[Name], "Unknown" ), "Unknown" )

[yakovlol]

Hello @bhelou thanks for the answer but it didn't work.

So I have a calculation group with 2 KPI's and for these two KPI's within calculation Item i have different calculations for each of them

And when i do this measure and Select % of hours in my slicer - it returns me the actual percent 40% - but not the word "Percent" and i cannot  find out why is that and how to change it

[bhelou]

Hi , kindly share some sample 

[yakovlol · Accepted solution]

To do dynamic titles when you're using the Calculation group, you should enable this "Title" that is calculated within the calculation group.

This video helped me to find a solution

https://www.youtube.com/watch?v=Op-JUSyP4XM