% of true/false expression in a KPI-chart

[André Odde]

Hi,

I have a column in my data set which is a yes/no column based on some criterias.

If Column A is bigger than Column B, then Yes, if not, NO.

What I want is to show the percentage of Yes and NO in a KPI-chart. It works fine when I'm putting it in a Pie-Chart and color it by "Column C".

If I'm writing an uniquecount of Column C in a KPI-chart it shows me the number of Yes and NO, but I want the percentage.

 

Anyone know the solution here

[Khushboo Rabadia]

Pie charts have built in functionality to show value or percentage for each sector based on total value.

KPI chart does not have that functionality so you will need to specify the custom expression if you would like to show percentage.

uniquecount([Column C]) then [Value]/sum([Value]) OVER (All([Axis.Tile]))