Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Please see the image shared below. I have a table in power BI that contains two columns that need different conditional formatting. I am ok with background colors or icons. The DCM column conditions are different thant he DCO conditions. Is there a way to do this? ANy help is apprecaited, thank you. I tried looking for other similar forum questions, could not seem to find an answer.
Solved! Go to Solution.
Hi Nemanja, I hope you saw my earl;ier reply. What you suggesteed was for a single level ability to use conditional formatting, I needed conditional formats that vary. So the only way I coul;d work around this was to split my data up into a new table ane then do discreetly. If you look at the first question, you see that the data is in one column. I Had to split it out into three columns in order to do the formatting like I wanted. Thanks, though.
Thanks for the reply, yes I understand how to do, but the problem is the columns are from one data source, not multiple as it seems your image shows. I need different conditional formats in the two columns. As mentioned in the first post, I want to have very different format needs for the DCM and DCO columns. The only other way I could think of is to split out the data, but doing that becomes problematic due to the blank values (i.e., one column in the table for DCO, DCM, and RDTC).
@tewtom when dealing with conditional formatting on percentages, i use this approach:
1) select visual
2) go to fields > click on arrow beside field that you want to assign conditional formatting
3) format style = Rules
4) start from Min to Max, pay attention to <, <= to make sure you covered all ranges. Use number: 10% = 0.1, 50% = 0.5
Here is example:
Cheers,
Nemanja Andic
Hi Nemanja, I hope you saw my earl;ier reply. What you suggesteed was for a single level ability to use conditional formatting, I needed conditional formats that vary. So the only way I coul;d work around this was to split my data up into a new table ane then do discreetly. If you look at the first question, you see that the data is in one column. I Had to split it out into three columns in order to do the formatting like I wanted. Thanks, though.
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |