Variable heading

[Zeta]

Hi all,

in a pie chart, I offer two alternative measures. Depending on which measure is selected, the heading should adapt.

If [measure 1] is selected, then ..., else ...

Does anyone have a solution for me?

[justISO · Accepted solution]

Hi, few weeks ago I tried to investigate similar possibility, but my findings was, that it seems you can't distinguish which alternative measure is selected in graphs. So you can't make adaptive label. But you can know what filters are selected, so best what I managed to do is to load additional table with my waned measure names, like:

LOAD * INLINE [
MeasureID, MeasureName

'1',  '1. measure1name'
'2', '2. measure2name'

... ];

Put that 'MeasureName' as filter. Made a measure which calculates different thing depending on what MeasureName is selected (linked to MeasurId):

if(MeasureID = '1', Sum( yourformula1),
if(MeasureID = '2', Sum(  yourformula2)...

And added expression to graphs title field:

 if(GetSelectedCount(MeasureName)=1, MeasureName, '---')

So when you filter one measure, your graph shows one graph and change graph name/heading accordingly.