Variable heading

Zeta — Mon, 21 Mar 2022 15:40:24 GMT

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?

Re: Variable heading

justISO — Tue, 22 Mar 2022 09:39:54 GMT

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.

topic Variable heading in App Development

Variable heading

Re: Variable heading