Forum Discussion

dia612's avatar
dia612
Helper IV
6 years ago
Solved

Values in Slicer

Hello,

 

How can we show exact values in slicer with values  rounded up to specific decimal or even without rounding up the values???

 

I have freq values in my table  

 

 

 

 

I am showing them in slicer but the values are getting rounded up.

 

I dont want them to be rounded up. I have to show the exact value present in the table.

If a click on the value it is showing the exact value like this

 

 

Is there a way to display the values exactly like in the table or to format it to specific decimals??

Any other visual to get that result???

 

  • dia612 , if you have selected the decimal place in data format, then it should that many if data is there till that decimal place

     

4 Replies

  • dia612 , if you have selected the decimal place in data format, then it should that many if data is there till that decimal place

     

    • dia612's avatar
      dia612
      Helper IV

      Hello amitchandak ,

       

      Thank you for replying.

      I have tried your suggestion , it is working 

      But instead of rounding up, if we want to show the values exactly as in table , how can we do that??

      (Bcoz in my table I have some values upto 2 decimals, some upto 5 decimals and some without any decimal values)

       

      Is there any way we can show the exact values as it is ?? I have to show them in Slicer Visual only.

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Community Support

        Hi dia612 ,

         

        You can change the value decimal places in field formatting:

         

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

         

        Best Regards,

        Dedmon Dai

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi dia612 ,

     

    Please try to change it to the List mode.

     

     

    Aiolos Zhao