Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Return different formats in the same calculation group

Hello everyone, 

 

I was using a calculation group to return the following table. In order to be able to show different types of numbers (entire and percentage). I used the FORMAT function inside each calculation item to return the correct format. 

 

 

 

 

However, since the last update of Power BI, using the format inside a calculation group broke my other graphs ( bar and line charts 😕 ). 

 

The solution that I have thought is to create to measure formatted as percentage and another as a whole number and then apply the calculation group to one of them and use the other one inside the calculation items where I needed to display %  

For instance, I'll apply the calculation group to a metric that is formatted as an whole number and inside the growth calculation items, I'll use the the percentage formatted metric 

         

 

However, this doesn't seem to work as shown bellow 

 

 

 

 

 

Could you please let me know if my solution is even possible or if there is another way to format my growth calculation items in percentage and display borth types in the same table

 

Thank you very much,

Mariem,

2 Replies

  • Hi Anonymous ,

     

    I have made some test with the February Version of PBI and did not loose any formatting with calculation groups.

     

    Can you share how you have used the format option on the calculation group? I just formatted each of the options within the format string expression directly without any format.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello MFelix 

       

      It seems that it's a bug and they have fixed it on the desktop version but not on the web services.

      I guess i'll not change anything and wait for them to update 

       

      Regards,

      Mariem