Color one specific column

Hi Meggie,

yes this works on one column, if you have one column or different Measures.

But, if you have a matrix, with a hole lot of columns with only one Measure, it dosn't work.

If you try Field formatting or conditional formatting, it will formate the hole table, because it works on the measure not the column.

But we only want to formate 2018, 2015 and 2021 in light grey, these are columns with cumulated values or forecast.

And if i add a second or third measure for cumulated or forecast, we will have more than one column per year, this is not aceptable, i explain:

Of course, we will drill down first to years (2015 will go to 1995 to 2015 and 2021+ will go to 2021 to 2034) and next we will drill down the Years to Months, so in the end of day, we have countless columns with three measures.

So we put together the three measures in one to display it.

That's my Problem. 

I forget, there is one more, small, restriction: We work on Live connection to Tabluar Model (too many values for Power BI ->Loadtime) , no way to add a calculated Column or Table in Power BI Desktop.

Example: Out Matrix looks like this:

And here you see the Drill-Down to Months

Works Power BI Desktop [may 2018] with the Power Bi Server?

Thanks for your help

Katja

For Field formatting menu I have download latest PBI (May 2022) desktop but still not available, do this feature require Pro license?

My problem is I'm trying to color code multiple columns, and they're based on measures. This is a very good thing to know if I want to color one column, however!