Reply
JaromBIDEVatDK
Helper II
Helper II
Partially syndicated - Outbound

Change column from matrix columns

Is there a simple way to check for changes between 1 & 2 in the image below. If there is a change I want to show the row. If no change then don't show row. 

 

JaromBIDEVatDK_0-1645564823878.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

Syndicated - Outbound

@JaromBIDEVatDK , You have to create a measure to get that change. and then you can use conditional formatting

 

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
JaromBIDEVatDK
Helper II
Helper II

Syndicated - Outbound

Thank you - Here is generally what I did for the measure to help others out if they come across this.

 

Measure = 

var oneCol = Calculate(Max(Attribute), Filter(AllExcept(emptable, employee), value = 1) 

var twoCol = Calculate(Max(Attribute), Filter(AllExcept(emptable, employee), value = 2) 

if(oneCol <> twoCol, 1 (or the difference))

 

In my case I didn't actually want the change column I wanted simply to hide rows that didn't change. So, with the measure above, I just put it on the visual filter, set the advanced option to "is" 1  and viola. 

amitchandak
Super User
Super User

Syndicated - Outbound

@JaromBIDEVatDK , You have to create a measure to get that change. and then you can use conditional formatting

 

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)