Slicer Won't Show Correct Values on Cards

[Anonymous]

Hi,

All of my slicers are working except the comment PO.

This slicer is taking from a table that i need to create because slicer will not be able to use measure.

My problem that it will not filter the cards as shown.

Thanks...tksnota...

[Anonymous]

Hi, @Anonymous 

Have you solved your problem yet? If not resolved, can you provide example files? Please remove any sensitive data in advance. Please also provide the output you expect.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

the values are specific because they dependent on the percentages which are also measures...

[MFelix]

The Comment is a Measure that you are using in that table visual is that it?

[Anonymous]

yes for visual only

[MFelix]

Hi @Anonymous ,

For this you need to redo you calculations in the card and also add a measure to filter out the values on the table.

Can you share a mockup of your model so I can refer what is the best option?

I have made a sample on my side by this will depend on the calculation on your side also, but for my example I have done the following:

[Anonymous]

Hi,

Are you able to share the pbix because it seems like this is the one that can solve my issue?

Thanks...tksnota...

[MFelix · Accepted solution]

Hi @Anonymous ,

Please see the file attach.

[Anonymous]

the comments are taken from a table that I created. the table is then taking the comments from the measure because i understand measures can't be used into slicers.

[MFelix]

Hi @Anonymous ,

Are the values for the Comments a specific values or they can be very different?

Try to create a dimension tables with the unique values for comments, make a relationship with the fact table and use that new table on the slicer.