Display units in charts with disconnected table of measures and SWITCH

[Pldoyon1]

Hello community, I have a bar and a pie chart where I use a measure with SWITCH and a disconnected table of many different measures in order to change the values. Charts in Power Bi can't display the units of each measures ($, %, etc) with SWITCH. I tried many possible solutions but I can't find the way to display the units correctly in charts. I tried FORMAT but it works only with tables. I tried Tabular editor with the calculation groups and I can't use it in my report. I tried other charts visuals. etc

So, do you know how I can solve this ?

Your help will be very appreciated.

Thanks

[Anonymous · Accepted solution]

Hi @Pldoyon1 ,

You could try to add tooltip in your visual.

Reference: Create tooltips based on report pages in Power BI Desktop

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pldoyon1]

Hello Stephen, thanks for your response. I don't know who put an accepted solution to your post because it's not. Power BI should be able to show the units in the visuals correctly and that's not the case unfortunately. The tooltip is a patch for this problem. Do you think that it would be ok to use tooltip in tables ? No ! It's the same for charts. I think that power bi should review the codes for their visuals in order to accept the units when we use SWITCH or any other way to correct this would be appreciate.

[Pldoyon1]

Thanks for your very quick response ! Tabular editor works fine but I have a very big report and it changes the behavior of my other visuals.

The text box is a good idea but I have a lot of measures and I can't do this. I can't use bookmarks including data in my report. 

[MattAllington]

I would add the formatting text box logic to the disconnected table.  You already have the switch measure for the measures.  Just add a column to the disconnected table with the formating choice per row (eg, "$", "%", "0").  Then duplicate the switch measure and write the logic to give you the format string you need for the text box. 

[Pldoyon1]

Yes, that's a good option thanks but I would definitely prefer to have it beside the data in the chart. I'm considering changing software because of this. I can't believe that Power Bi doesn't have this basic functionnality. It's a dashboard software with charts that doesn't show the units correctly ! Do you know if they're planning to change this eventually ?

[MattAllington]

If TE doesn't work, you may be out of luck. Maybe you could use no formatting at all for the measure and create a text box that generates the correct units and place that next to the axis.