Conditional Formatting based on variable parameters

[Anonymous]

Hi everyone,

I'm having  columns in a report for which I want to show trend based icons. I could solve this by conditonal formatting; the problem is that I have a lot of columns and a lot of reports for which I'd like to do that, but they all rely on the same conditions. Therefore I would like to have a hidden report which is just stating the parameters for the conditional formatting, which I want to use for conditional formatting in all the other reports. This approach has the advantage that I don't have to change each column each time I'm changing the parameters for the trend based icons.

Is there any way to do that? I appreciate all ideas!

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could use what-if parameter and create a measure like below.

Parameter = GENERATESERIES(0, 3, 1)

Parameter Value = SELECTEDVALUE('Parameter'[Parameter])

Measure 4 = SWITCH(TRUE(),Parameter[Parameter Value]<1,[Measure],Parameter[Parameter Value]>=1&&Parameter[Parameter Value]<2,[Measure 2],Parameter[Parameter Value]>2,[Measure 3])

Result would be shown as below.

Best Regards,

Jay

[amitchandak]

@Anonymous , not very clear. But you can create icon measure and color measures and use those. refer to these blogs and see if they can help

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

[Anonymous]

Thanks for your suggestions! It's heading in the right direction.

I'll try to specify what I want:

I want to have KPI for multiple columns and reports. The particularity is that they all depend on the same threshold values for the rules. Instead of retyping this every time or copying it around, I'd like to generaliye it so that if the values for the KPI changes, I just have to change it one time and for multiple columns and reports.

My idea is that I have a variable x, if x<1 I want to KPI 1, if 1<= x <2 I want to return KPI 2 and finally for x>2 it should be KPI 3.

This rule should be applied to different columns with different measures, so that I get a KPI for each field.

Basically I could just apply this rule to each column by hand, but I would like to formalize it. So that - if my thresholds for the rule changes - I just have to change it one time and it applys to all columns which rely on the variable of the generalized rule and I don't have to change all the conditional formatting on the columns of my table.

Please tell me, if I have to elaborate this further, I'm quite new to Power BI but have worked with other reporting tools in the past.