Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Katja
Frequent Visitor

Color one specific column

Hello,

 

i have a matrix and i'll like to color this one column, because, left of this column are current values, right of this column are planed values. the column itself contains the forecast für the depending year i.a. 2018. the value itself is a measure and calculates current/plan or forecast in one measure, depending on the years/month (columns) and accounts (rows) come out of tabular model.

We want to drill down the columns and the rows.

 

Ist this possible in Power Bi Dekstop [march 2018] to color one specific column?

14 REPLIES 14
Anonym
Regular Visitor

You're able to color whole columns with Measures.

You have to set a measure as the background for the values in your matrix. Then you have to create the code in the measure, for example:

ColorColumns =
var _val = SELECTEDVALUE(nameoftable[nameofcolumn])

return SWITCH(_val, "forecast1", "#ff9933", "#ffffff")

 

In this example every value forecast1 in the column would be colored orange, and everything else white

guh950
Microsoft Employee
Microsoft Employee

This looks good, but how would I set a measure to color code for another measure column in a matrix?

v-juanli-msft
Community Support
Community Support

Hi @Katja

With Field formatting for matrix, you can color one specific column. (this can be achieved in Power Bi Dekstop [march 2018])

With conditional formatting for matrix, you can specify customized cell colors based on cell values, or based on other values or fields.  (this need to update to Power Bi Dekstop [may 2018])

2.png

 

Best Regards

Maggie

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!

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

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:

image.png

 

And here you see the Drill-Down to Months

Pic2.JPG

 

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

 

Thanks for your help

Katja

Hi @Katja

with May 2018, I can color specific columns

7.png

8.png

 

Best Regards

Maggie

How would I apply similar to multiple measures on the same table?

 

Something like what is in the following table (separate background colors for each column)

 

guh950_0-1653079067794.png

 

Anonymous
Not applicable

Hi @v-juanli-msft ,

 

How can we color specific column if the columns are text(I have proficiency levels -Begininning,Mastery etc) instead of Years?

Okay,

so i have to wait until the Server for May 2018 is released.

 

In the Version for march 2018 - the newest Version for Server - i can't find this option.

 

The conditional formating for the columns, can you set the year's felxible or only "hard coded"?

 

 

Thanks.

Katja

Hi @Katja

"Server for May 2018" refer to Power BI Desktop 2018 May version, right?

It is released since last month.

I need set the year's only "hard coded" as the picture shown.

 

Best regards

Maggie

Hi Maggie,

 

yes thats right.

But i can't find the Download for Server May 2018, only March 2018.

 

My Link: 

https://www.microsoft.com/en-us/download/details.aspx?id=56722

 

is there a other one?

 

Thanks

Katja

Yes,

this is the Link for downloading the PB Desktop.

But i guess this Version ist the "normal" Version for PB Service.

 

We use the PB Server, not Service. The Server is - i think- only in Version March 2018 released.

The Desktop for Service Version has no option to store on local Server.

And a few options less....

 

Thanks

Katja

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.