Forum Discussion

JHammer's avatar
JHammer
Frequent Visitor
8 years ago

Change decimal places in Visualisation by slicer selection

Hi

 

I am using the one Value column which have to different types of numbers (whole numbers and decimal numbers). I want to my only visualization change showing value decimal places by slicer selection -> type of number( whole number = no decimals showing and decimal number = 2 decimals showing). Is this possible?

 

Image of Value column:

https://imgur.com/a/btFUCaq

Need Help

3 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    8 years ago
    Hi@JHammer 
    You try it following my steps as below:
    Step 1:
    Add a table included type column  'whole numbers' and 'decimal numbers' 
    Step 2:
    Add a measure :
    Measure =
IF (
    SELECTEDVALUE ( Table1[Type] ) = "whole numbers",
    FORMAT ( INT ( MIN ( Table3[Values] ) ), "###" ),
    IF (
        SELECTEDVALUE ( Table1[Type] ) = "decimal numbers",
        ROUND ( MIN ( Table3[Values] ), 2 ),
        MIN ( Table3[Values] )
    )
)
    Result :
     
    and here is the Demo ,please try it
     
    Best Regards,
    Lin
    • JHammer's avatar
      JHammer
      Frequent Visitor
      8 years ago

      Thanks! That's nice, but I need to change Clustered column chart > Data Labels > Value decimal places: based on slicer selection (whole numbers = value decimal places: 0 and decimal numbers = value decimal places: 2. Is that possible?

       

      All my values are in same column and I dont want to use Bookmarks with two different Clurestered column charts, because that's not working because I have to add buttons to change bookmarks and other slicer selections not sync to another Bookmark.

       

       

       

      • v-lili6-msft's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support
        8 years ago

        Hi@ JHammer

        After my research, I’m afraid we can’t change it for now,

        you could post your new idea in Power BI  ideas  and make this feature coming sooner .

         

        Best Regards,

        Lin