Convert Column to Measure...

Question

Greetings -&nbsp;I am trying to replace an excel sheet w/ "conditional formating" w/ PowerBI...I know that you can only do "conditional formatting" in PowerBi w/ columns that are 'measures' - but in my scenario, the values in my data are already calculated, I just need to add the visual formating....Example -In excel, i have this...&nbsp;But in PowerBi, I cannot achive becasue 'score' is not a measure...&nbsp;&nbsp;&nbsp;So, my thought was to create a new 'measure column' so that I can conditional format it....Something like 'NewMeasureColumn = 'myTable'[score] * 1' &nbsp;- that way the value never changes....but I cannot figure this out....Is something like this possible?Has anyone figured out a simple way to convert a value into a measure so you can apply conditional formating?&nbsp;Thanks!

mfelix · Answer

Hi&nbsp;ihayes916,&nbsp;What you can do is a workaround based that your data don't have any ID.&nbsp;1 - Add one of the columns to you table and don't summarize it2 - Add the other columns and select the MAX / &nbsp;MIN values3 - Apply the condittional formatting to the MAX columns4 - Reduce the size of the &nbsp;first column to hide it&nbsp;&nbsp;&nbsp;Regards,MFelix&nbsp;

mfelix · Answer

Hi ihayes916,You can apply conditional formatting to values from columns or measure the values have to be numbers but it applicable to both.Regards,MFelix

ihayes916 · Answer

MFelix&nbsp;- thank you for your reply.&nbsp;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...&nbsp;But...if i do some type of aggregate function (SUM) then I can apply conditional formating...but this messes up my numbers...&nbsp;&nbsp;Thoughts?

mfelix · Answer

Hi&nbsp;ihayes916,&nbsp;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.&nbsp;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.&nbsp;Regards,MFelix

ihayes916 · Answer

MFelix&nbsp;- again, thanks and apologizies for the lack of calrity...&nbsp;The data that I am dealing w/ is flat, non-relational data w/ no ID column. &nbsp;:(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. &nbsp;They then take that CSV and append the data to an existing excel workbook that has a bunch of formulas in it....&nbsp;The end result (in excel) looks something like this... (this is what I want to reproduce)&nbsp;And this is the formating rule they use...&nbsp;&nbsp;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....&nbsp;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...&nbsp;Thanks!Isaac&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Convert Column to Measure...

8 Replies

Related content

Convert measure to column

Convert calculated column into measure

Convert column to measure

Convert Measure to Column

Measure two columns