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 thr slicer it displayes the information related to that particular filter, which is normal behaviour.

Wat is my requirement is if i dont select any of the filters the result should be empty, if i select any filter then only it should display the values.

 

Any Ideas please answer me ASAP.

Need Help
Show and Tell

3 Replies

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

    Hi ravikumarmb,

     

    What I would suggest is to create a measure or modify a exist measure like it below.

    Measure =
IF ( HASONEVALUE ( [the slicer field] ), [your current measure], BLANK () )

    If you have more questions, please post a little sample. 

     

    Best Regards!

    Dale

    • 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