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 sele...
Need Help
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