Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Greetings -
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...
But in PowerBi, I cannot achive becasue 'score' is not a measure...
So, my thought was to create a new 'measure column' so that I can conditional format it....
Something like 'NewMeasureColumn = 'myTable'[score] * 1' - 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?
Thanks!
Hi @ihayes916,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |