Forum Discussion
Convert Column to Measure...
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