Forum Discussion
Convert Column to Measure...
You can apply conditional formatting to values from columns or measure the values have to be numbers but it applicable to both.
Regards,
MFelix
MFelix - thank you for your reply.
Unless I am missing something painfully obvious, you can only apply conditional formating to 'Measures' or 'Aggregated Values', right?
I have column, 'score', that is a number...but when I select that column...I cannot apply any conditional formating...
But...if i do some type of aggregate function (SUM) then I can apply conditional formating...but this messes up my numbers...
Thoughts?
Hi ihayes916,
In your explanation I didn't understood that your data was in a non aggregated way, if you use a measure since it's based on context you also need to have a aggregator. Is your data one to one? Meaning that your ID column in the table correspond only to one value? you could aggregate the values with a max or a average and then apply the conditional formatting.
Without any further information about your data is not easy to give you a solution of a measure, if you can give some sample data and the expected result I cna give you a better answer.
Regards,
MFelix
MFelix - again, thanks and apologizies for the lack of calrity...
The data that I am dealing w/ is flat, non-relational data w/ no ID column. :(
As it stands today, someone runs a SQL query and exports the results as a flat CSV. The SQL job does all the calculations so there is very little for Power BI to do. They then take that CSV and append the data to an existing excel workbook that has a bunch of formulas in it....The end result (in excel) looks something like this... (this is what I want to reproduce)
And this is the formating rule they use...
Then they email this workbook to various people....my goal is to simply reproduce this in PowerBi so they can just press "refresh", have it import said CSV from a desiginated folder, then they can publish the report online, etc, etc....
I think it just comes down to the fact that PowerBI does not handle "conditional formating" in the same way that Excel does...and I was really expecting it to...
Thanks!
Isaac
Hi ihayes916,
What you can do is a workaround based that your data don't have any ID.
1 - Add one of the columns to you table and don't summarize it
2 - Add the other columns and select the MAX / MIN values
3 - Apply the condittional formatting to the MAX columns
4 - Reduce the size of the first column to hide it
Regards,
MFelix