cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jengwt Resolver I
Resolver I

Get selectable measures on line chart to show as percentages

Hello, I am having some trouble with some selectable measures being displayed in a line graph and a matrix.

I inherited this report and am thinking about reworking it in future. But for the time being I just need to get it to work.

 

The user is to select from a list of measures that which they want displayed on a line chart. The actual data on that chart is displayed below in a matrix which is not necessarily to be responsive to the list slicer.

 

The slicer pulls from a list of names of measures which are themselves in their own table. A switch measure then determines which measure is selected by the user, and then displays the selected measure.

 

This system works. However, percentage numbers are not displayed as percentages, despite those measures being listed as percentages. In order to make them display as percentages in the matrix, I have to use the FORMAT() function. I have not been able to get them to successfully display as actual percentages in the graph. Using the FORMAT() function in conjunction with the graph actually breaks the graph; it goes blank.

 

So, what I need to know is:

1) How do I get those numbers to actually display as percentages on the graph.

2) Why does this work for the matrix, but not the graph? What am I doing wrong? Where is the disconnect?

3) Any ideas on other ways I could concisely-ish display over a dozen measures?

 

Thank you for your help!

 

Slicer.PNGPercentChart.PNG

SwitchMeasure.PNG

2 REPLIES 2
Super User III
Super User III

Re: Get selectable measures on line chart to show as percentages

Hi @jengwt ,

 

When using the FORMAT syntax you are transforming you value in text so it cannot be used in a chart although in a table, matrix or card work perfectly. One workaround can be to multiply the value of those percentages by 100 and then make a card to place above the chart  Y-axis telling the units something similar to this:

 

%.gif

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog:

Power BI em Português





Highlighted
jengwt Resolver I
Resolver I

Re: Get selectable measures on line chart to show as percentages

@MFelix I see. And have the Y-axis label change depending on the selected measure. That's pretty ghetto, but until it could work for the time being. Thanks for your response.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors