Issue: Power KPI matrix visual issue for if / switch function based measures

[Anonymous]

Hi,

I am using Power KPI matrix visual in  my report and found the which measures are created through if and switch function are not updating which passing the logic. it is showing only else criteria value.

For Example, I am comparing this year financial vs Budget / Last year. For Budget / Last year, I created a measure through if function -

Business Profit Comp =
IF(
[Comparison Type]=1,[TY YTD Business Profit Budget], [LY YTD Business Profit Actual]
)

The above function is working absolutely fine in Table / Materix visual, but in Power KPI materix is returning only else measure value.

Please healp. 

[v-jiascu-msft]

Hi @Anonymous,

Can you provide a dummy sample please? If you can, you can upload the pbix file to the Onedrive or GoogleDrive then send me a private message with link.

Based on my test, the possible cause is context. I guess there isn't a field of [Comparison Type] in your visual. So the [Comparison Type] value is always the same.

Best Regards,

Dale

[pcraokjr]

Hi

I'm using Power KPI Matrix latest version PowerKPIMatrix.2.1.1.0.pbiviz, but unfortunately its not displaying the KPI Indicators icon which set as part of KPI Indicator formatting menu. Is anyone faced similar issue to display KPI Indicators icons. if so Please provide solution

Thanks