Forum Discussion
Color column conditions
Hi POWER_MI ，
You can create a table like :
Then use the following measure :
Measure 2 = CALCULATE(COUNTA(COLOR_FIELD_TO_ADD[Coulumn]),FILTER(COLOR_FIELD_TO_ADD,NOT(ISERROR(FIND(COLOR_FIELD_TO_ADD[Coulumn],MAX('Table'[ROWS]))))))Set background color for [measure2] by field [colorformat]:
For more details, please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EYCIfcnfrjNKoZ4x1HCEzPkB5QOxQggIjQVIQdbaS7p3cQ?e=tdyg3j
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi POWER_MI ,
Please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EQToaVM-Vo9Cn58eS90lg9oBdHq_ygXiO8FIhwizkpC6qA?e=6GwsQP
If this post help, please consider accept it as the solution to help other member find it more quickly.
Best Regards,
Dedmon Dai
thanks a lot for you answer.
i have detailed some updates with some updates of problemes :The objectif is to add on Power Bi dashboard Button or list where the user can chose here color step :
The Value will be same count of Ri at Step i.
See picture
The Row of Power BI dashbord will be same
Table 3 rows and 7 column for Step.
In Rows it's will depand on choice of user If A table 1 will be displayed, if B table 2 if C table 3 depending on R1... color like explained on picture.
Thanks a lot for help
You can find Power BI project her "COLOR FILED TO ADD"
Link : click here