Forum Discussion
Convert Column to Measure...
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
FANTASTIC!!!!!!!! This is definately a step in the right direction for me!!!!! Thank you!
Last question on this....you asked about an "ID Column"....
If I added an "Auto ID" column on data import (an incrementing number, starting at 0) would it allow for a different (less of a workaround) solution?
Again...thank you!
I was assuming that the ID was something that you would have to make a summarize SUM, AVERAGE to have the values of your score since there is no need to summarize you can use this.
The ID will only help you if you need to have it sort by a certain order.
Regards,
MFelix