Forum Discussion

ravikumarmb's avatar
ravikumarmb
Regular Visitor
9 years ago

Slicer Function

Hi,   I have  got  requirement where in i need to show few metrics based on text slicer. The values which i need to disply is text which i am showing in Table Visual. If we select a filter from t...
Need Help
Show and Tell
ravikumarmb's avatar
ravikumarmb
Regular Visitor
9 years ago

Thanks for the reply dale.

 

My feilds are not caculated measures, those are directly feilds cmg from the source and all text feilds not numeric values.

 

In slicer if do not select any value the result visulial should show empty, it should not show all the values is my requirement, only when we select any field in the slicer then only it should values else it should be empty.

 

 

Thanks

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi ravikumarmb,

 

I am afraid this is too hard to achieve. Let's have a look at these situations in your scenario:

1. If I have created several visuals, then I add a slicer in the report, suddenly, all the visual go blank. That isn't the way a slicer or a filter works.

2. If I just don't want a slicer, I have to add a slicer and select all the options. Or the other visuals would be blank. This isn't convenient.

3. If I have a large number of slicers, I want to test just one slicer. I have to select all the options of all the other slicers. This isn't convenient too. 

 

If you post some sample, Maybe we can find out a workaround. If you still want this feature, please submit an idea here: power-bi-ideas.

Please reference this similar post: Empty-table-with-a-slicer 

 

Best Regards!

Dale