Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there,
my need is to color 2 cells of the same column if they have the same value or anyway to make evident that there is a matching between 2 rows, for example:
REF | COLORTHAT |
ABC | THISYES |
DEF | THISNO |
GHI | THISYES |
I think the solution should be in Select column and using a Count Distinct, in this way in presence of a double or more values I should know if this cell value is repeated, but I really don't know how to do that.
Please help.
thanks
Solved! Go to Solution.
@Mikahel369 Perhaps a calculated column like this:
Count the Same Column =
COUNTROWS(FILTER('Table',[COLORTHAT] = EARLIER(Table[COLORTHAT])))
Then a rule that if this column > 1, show as red.
As always happen to me, when I make the question I found the solution... and actually was still here but with another "title":
Solved: How to count the occurrence of values in a column ... - Microsoft Power BI Community
after created the measure I just created the conditional formatting over the new column (new measure) and over the cell it self that shown the same values.
May help someone else.
@Mikahel369 Perhaps a calculated column like this:
Count the Same Column =
COUNTROWS(FILTER('Table',[COLORTHAT] = EARLIER(Table[COLORTHAT])))
Then a rule that if this column > 1, show as red.
Ok great, this is even better than what I found.
Thanks
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |