Forum Discussion
Conditional formatting with multiple column/bar values
I have multiple measures and for each of them specific limits and warnings which I have calculated indivuadully. As you said, I need to apply conditional formatting for each measure with a specific rule depending of their calculated limits, and plot them in the same visual that has the custom filter i made, which allows me represent only one of the multimple measures.
I don't know if I have explained myself properly, my english is not as good as it should.
Thank you.
Hi Anonymous ,
Not really sure if this is what you need but using a disconnected table with the measure and making them part of the x-axis you are abble to have a single measure to have the condittional formatting working check the image below if this appearance looks good to you or what is missing.
Again if you can share a mockup of your data would be easier to achieve an answer.
Hi Miguel, I was reading the question and looking at your solution and this is exactly what I'm trying to do. I have a clustered bar and line chart with Actuals and Forecast as the bars. I would like to conditionally format the Actuals bar so that is a different color if we're still within the current month. Looks like your solution would work. Could you provide a few more details on making the measures part of the x-axis? Could you provide a sample file? Thanks!
Hi rrhascall
Just to have a more clear idea are your actuals and forecast in the same table?
Do you have a calendar table?
Yes, actuals and forecast are in the same table. I am using a calendar table but it is not marked as a date table because I'm only using monthly values (month + year) . PowerBI won't let me mark as a true date table because of non-continguous dates
