Change decimal places in Visualisation by slicer selection

[JHammer]

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

[v-lili6-msft]

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

https://www.dropbox.com/s/wjrcfdryrebnagh/Change%20decimal%20places%20in%20Visualisation%20by%20slic...

Best Regards,

Lin

[JHammer]

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]

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