Forum Discussion
Conditional Formatting while drag and drop the column
This is not possible in Power BI. There is no mechanism that automatically applies conditional formatting when a column is dragged into a table visual. The "fx" wiring step in the Format pane is always required, and it is a one-time manual setup per column per visual.
I don't think you can do that. That's not the correct steps in Powerbi. In Powerbi, 1st drag out the column to the table, 2nd, set the conditional formatting.
you can try this
Hello ryan_mayu,
Good day!!!
Thank you for the dax!!!
Once we created the dax we go to conditional formatting and selecting the fields to change the colors of the background.
Here the requirement is, when we drag the column the color should be available. We dont need to make the background changes by selecting the field.
can you help on this.
does that mean you will change the column to other columns?
I think we build the table first, then set up the conditional formatting. If you didn't drag out the column , I don't think we can set up the conditional formatting.
If I misunderstood, pls clarify your requirements and update the expected output.
hi ryan_mayu
We are creating the table 1st, then we have the column in the table. When we directly drag and drop the data in the table visual, it has to show the conditional formatting color.
Usually, when we drag and drop into the visual from the column, we will go to conditional formatting and make the changes as per field. Here, directly when we drag and drop the column in the visual, the color must automatically change without changing anything from conditional formatting. Can we able to do with any DAX?I don't think you can do that. That's not the correct steps in Powerbi. In Powerbi, 1st drag out the column to the table, 2nd, set the conditional formatting.