Conditional formatting - Matrix by column instead of the entire dataset

[Anonymous]

Hello Guys

I created a Matrix visual in Powebi which contains on the header "Months" and the row "Customers". I am just counting the number of items per customer.

I am trying to figure out if there is a way to use conditional formatting to go on the basis of the column, instead of  the entire of the matrix.

Such as when I use the Lowest value to Highest color scale, it will compare the values of the whole table, when I wanna  the conditional formatting to compare lowest to highest of only the values in columns.

Is it possible to do that?

Thanks

[tex628]

You need to create another measure to do your conditional formatting on.

if you have a table like this: 

	USA	SPAIN	SWEDEN	DENMARK
Jan	10	20	10	10
Feb	20	19	31	91
Mar	30	20	35	31
Apr	50	30	12	42

Create a measure that calculates the share of the individual row i relation to the country:

Measure = 
SUM('Table'[Amount]') / CALCULATE(SUM('Table'[Amount]) ; ALL('Calendar'))

 
Then you use that measure as the 'Based on field' on your conditional formatting:

[Anonymous]

I dont have a table like that

---

@tex628 wrote:

You need to create another measure to do your conditional formatting on.

if you have a table like this: 

	USA	SPAIN	SWEDEN	DENMARK
Jan	10	20	10	10
Feb	20	19	31	91
Mar	30	20	35	31
Apr	50	30	12	42

Create a measure that calculates the share of the individual row i relation to the country:

Measure = 
SUM('Table'[Amount]') / CALCULATE(SUM('Table'[Amount]) ; ALL('Calendar'))

 
Then you use that measure as the 'Based on field' on your conditional formatting:

---

---

@tex628 wrote:

You need to create another measure to do your conditional formatting on.

if you have a table like this: 

	USA	SPAIN	SWEDEN	DENMARK
Jan	10	20	10	10
Feb	20	19	31	91
Mar	30	20	35	31
Apr	50	30	12	42

Create a measure that calculates the share of the individual row i relation to the country:

Measure = 
SUM('Table'[Amount]') / CALCULATE(SUM('Table'[Amount]) ; ALL('Calendar'))

 
Then you use that measure as the 'Based on field' on your conditional formatting:

---

In my case 
Month comes from Calendar table and customer comes from customers table 
The values i have a measure called Items received. Even so it possible to achieve your first table based on the my current situation ?

[tex628]

In that case it should just be the opposite, replace the filter on calendar with customer:

Measure = 
SUM('Table'[Amount]') / CALCULATE(SUM('Table'[Amount]) ; ALL('Customer'))

Let me know if it works! 

[Anonymous]

Give us a graphic representation to get your point...is still quite open your question.... pictures and exel examples of what you have and how would be your expected result.

[Anonymous]

Hello 

Thanks for your help

Please see below what i m trying to achieve

I have the table below in powerbi and i m using the  the conditional formating  in a Matrix visual which contains on the header "Months" and the row "Customers"

I m using the Lowest value to Highest color scale.

What do i need to do?

I would like to put a conditional formatting for each month as per the conditional column. 

Currently, conditional formating in PowerBi works by appling to a range of values in a single column, when you create a Matrix visual using fields such as "MonthYear", all values come from this original single column, thus conditional formatting goes on the entire Matrix.

[TeigeGao]

Hi @Anonymous ,

Actually, the Conditional formatting in Matrix is based on the column rather than whole dataset, in your scenario, for each month, it will sort data differently.

Best Regards,

Teige