- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
10-10-2024 04:47 AM | |||
07-17-2024 03:26 AM | |||
Anonymous
| 06-17-2024 12:39 AM | ||
Anonymous
| 01-19-2024 12:24 AM | ||
04-21-2023 12:00 AM |
User | Count |
---|---|
87 | |
81 | |
53 | |
38 | |
35 |