Is it possible to create a slicer/legend?

[Anonymous]

 Hello all,

I am trying to incorporate a colored "category" legend that would also serves as a slicer for my report.  It seems like it should be easy but is not.
I am kind of disappointed this is not built into PBI.  I have watch users intuitively try to click my static legend over and over.
I have proposed this capability here.

Below is what I have now.  It uses the Chiclet add-on, creative padding, transparancy and separate colored objects .

However, this approach is dependent on all data categories being represented in the dataset so the colors line up, which is not guaranteed.
Adding "dummy" records to ensure representation of all categories, creates "(Blank)" values  in my other slicer drop-downs (fly-out panel not shown).  Page filters to remove these, also affect the slicer.

Round and round it goes.

Things I have tried:

1. Chiclet Slicer
   The use of logo images is not acceptable because my client limits use of outside resources and challenges finding an acceptable internal hosting workaround.
   (FYI, https://dummyimage.com is a site I found that will dynamically render images from a URL string that passes color, size, text and file format.  Incredibly useful for those who can use outside resources.)
   
   
2. Stacked Column Chart / Legend
   This would be a dynamic solution and dummy data would not be required and seems promising.  However, the axis values disappear when I size the visual any where close to desired.
   Is there a way to move the category labels up into the column, like you can in Excel?
   

What am I missing?  Any other suggestions?

Thank you.

[parry2k]

@Anonymous whatever you throw on the value section in the matrix visual, you can apply conditional formatting to that measure. Just click the arrow next to what you have in the value section and that is where you will find conditional formatting options.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@Anonymous I think it is going to be a mix of matrix visual and conditional formatting, but the experience with matrix visual is not going to be great, as you will able to slice the data by clicking on one cell and to select multiple cells, one has to hold the cells, it is not a TRUE slicer but can surely do the job. 

And of course, color codes for each category will be stored in a table so that the same colors can be applied using conditional formatting. 

[Anonymous]

@parry2k,

Apologies, I have only just started exploring Conditional Formatting and I don't see where to apply it anywhere in the matrix visual.
Can you point me in the right direction?

Thank you.