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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
MarvinBangert
Regular Visitor

Slicer conditional formatting value border color

Hi everyone!

 

Background:

I have a report that gives me an overview about a file migration, I use a slicer to filter for the extension of a file:

MarvinBangert_0-1660922556744.png

It should be easy for users (and me) to see which file types are not supported. I have a second table where I can fill in all supported extensions:

MarvinBangert_1-1660922657979.png MarvinBangert_2-1660922772263.png

I created a column using the following formular:

Extension Check = 
VAR _SEL =
SELECTCOLUMNS('Valid Extension',"Title",[Titel])
RETURN
IF(Scan[SourceExtension] IN _SEL, 0, 1)

This gives me a column with 0 if the extension is in the list and an 1 if it's not.

To make it easier to immediatly see the "not supported" extensions, I want to have something visual within the slicer. The only option I found was the "Border color" within "Values":

MarvinBangert_3-1660923025047.png

 

The problem:

I want to use the "conditional formatting" option to change the color depending on the supported / not supported extensions from the other list. e.g.:

MarvinBangert_4-1660923194219.png

But within the conditional formatting window, I need to select a summarization, so my values within the column are not working:

MarvinBangert_5-1660923400110.png

My calculated column is formatted as:

MarvinBangert_6-1660923612627.png

 

Does someone has an idea how to accomplish this?

 

Thanks in advance!
Marvin

1 ACCEPTED SOLUTION
MarvinBangert
Regular Visitor

I didn't find any solution how to do the formatting, if someone has an idea, feel free to answer.

 

I came around with this solution, that works for me:

 

I created another table using

Extension Check = DISTINCT(SELECTCOLUMNS(Scan,"Extension",[SourceExtension]))

So I just have a distinct list of all my extensions. Then I use the same formular as above to create a new column:

Extension Check = 
VAR _SEL =
SELECTCOLUMNS('Valid Extension',"Title",[Title])
RETURN
IF('Extension Check'[Extension] IN _SEL, "Supported", "Unsupported")

But this time I put in "Supported" and "Unsupported". This gives me a list with all distinct values and a column if it's supported or not. Using the relationship between the "Scan" and "Extension Check" table using 1-* on the column extension, I can get use the slicer with a second level:

MarvinBangert_0-1660946217349.png

This also helps me to easily select all unsupported or supported extension and solves my problem!

 

Best regard

Marvin

View solution in original post

1 REPLY 1
MarvinBangert
Regular Visitor

I didn't find any solution how to do the formatting, if someone has an idea, feel free to answer.

 

I came around with this solution, that works for me:

 

I created another table using

Extension Check = DISTINCT(SELECTCOLUMNS(Scan,"Extension",[SourceExtension]))

So I just have a distinct list of all my extensions. Then I use the same formular as above to create a new column:

Extension Check = 
VAR _SEL =
SELECTCOLUMNS('Valid Extension',"Title",[Title])
RETURN
IF('Extension Check'[Extension] IN _SEL, "Supported", "Unsupported")

But this time I put in "Supported" and "Unsupported". This gives me a list with all distinct values and a column if it's supported or not. Using the relationship between the "Scan" and "Extension Check" table using 1-* on the column extension, I can get use the slicer with a second level:

MarvinBangert_0-1660946217349.png

This also helps me to easily select all unsupported or supported extension and solves my problem!

 

Best regard

Marvin

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.