Forum Discussion

kkalyanrr's avatar
kkalyanrr
Helper V
7 years ago
Solved

Creating a dynamic chart(with formats Number and Percentage)

Hello,   I'm trying to creat a dynamic chart(Stacked Bar Chart)  which can display a metric in both number and percentage formats.. I tried creating a switch measure with appropriate formulae bu...
Need Help
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi kkalyanrr,

     

    It is not supported to make a measure to dynamically return different data types for result. As you can in below screenshot, using FORMAT function to format result converts the data type to Text which resulted in the blank chart.

     

    Best regards,

    Yuliana Gu

itsmebvk's avatar
itsmebvk
Continued Contributor
7 years ago

kkalyanrr I am able to switch measure and format it using following formula

 

Swith = SWITCH(TRUE(),Report[Column]="Number",FORMAT([Number],0),Report[Column]="Percentage",FORMAT([Percentage],"Percent")
kkalyanrr's avatar
kkalyanrr
Helper V
7 years ago

itsmebvk

Its working fine for Card chart but not with the  Bar Charts..Please see the attached screenshot.


  • itsmebvk's avatar
    itsmebvk
    Continued Contributor
    7 years ago

    kkalyanrr Apparently I am also observing same issue, I had gone through few threads, they also facing same issue, seems to be limitations in PBI as far as my understanding.