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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Conditional formatting not working when column value in data source is spread to columns in Matrix

Hi

I am facing issue with conditional formating in Matrix visual. I have create hierarachy to enable drill functionality in Power BI. 

Currently, I receive data in the following format and the amount of data that i receive is huge.

Columns name:  country, state, city, score, metrics. number of response

 

My output visual that I have created looks like below .

 metricAmetricBmetricC
Country753
    State682

            City

 

871

 

The value that is visible above is calculated measure (weighted average of response and score). To create this visual i added hierarchy in Rows, in columns i added metric and in values i added calcuated measure (weighted average). 

 

Now the issue I am facing is while doing conditional formatting. I am not able to do conditional formatting at metric level (metricA, B, C). If I do conditional formatting by measure that I created, it is taking all values in the measure for calculating minimum and maximum value. However, I want the series for conditional formatting should be different for metrics A, metric B and metric C.

 

Any help appreciated

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@Anonymous 

 

Hi, you can obtain this, using a Conditional Formatting - Format by Field Value (Use the measure)

 

and to assign the colors a measure like this:

 

Colors =
VAR _MAX =
    MAXX ( ALLSELECTED ( TableA[Category] ), [SumLikes] )
VAR _MIN =
    MINX ( ALLSELECTED ( TableA[Category] ), [SumLikes] )
RETURN
    SWITCH ( TRUE (); [SumLikes] = _MAX, "Green", [SumLikes] = _MIN, "Red" )

Img1.png

Regards

 

Victor

Lima - Peru




Lima - Peru

View solution in original post

2 REPLIES 2
Vvelarde
Community Champion
Community Champion

@Anonymous 

 

Hi, you can obtain this, using a Conditional Formatting - Format by Field Value (Use the measure)

 

and to assign the colors a measure like this:

 

Colors =
VAR _MAX =
    MAXX ( ALLSELECTED ( TableA[Category] ), [SumLikes] )
VAR _MIN =
    MINX ( ALLSELECTED ( TableA[Category] ), [SumLikes] )
RETURN
    SWITCH ( TRUE (); [SumLikes] = _MAX, "Green", [SumLikes] = _MIN, "Red" )

Img1.png

Regards

 

Victor

Lima - Peru




Lima - Peru
Anonymous
Not applicable

Thanks @Vvelarde I was able to implement change using your suggestion. 

 

Regards,

Rakesh.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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