Forum Discussion
Conditional formatting in visual for multiple duplicates
- Anonymous4 years ago
Hi Anonymous ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Create a measure as below to get the count of systems which per user logged into
Countofsystem = CALCULATE ( DISTINCTCOUNT ( 'Table'[System] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Current User] = SELECTEDVALUE ( 'Table'[Current User] ) ) )2. Create a measure as below to make conditional formatting rule
Conditional formatting = IF ( [Countofsystem] >= 2, "Red" )3. Configure conditional formatting: select the visual and click the field "Current User", Conditional formatting-->Background color
Best Regards
Hi Anonymous ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Create a measure as below to get the count of systems which per user logged into
Countofsystem =
CALCULATE (
DISTINCTCOUNT ( 'Table'[System] ),
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[Current User] = SELECTEDVALUE ( 'Table'[Current User] )
)
)
2. Create a measure as below to make conditional formatting rule
Conditional formatting = IF ( [Countofsystem] >= 2, "Red" )
3. Configure conditional formatting: select the visual and click the field "Current User", Conditional formatting-->Background color
Best Regards
Thanks a lot!!! It did work!!!