Measure to display percentage

[Anonymous]

Hello all,

my issue is a little complex:

I created a report in which you can change what a visual displays via a slicer, similiar to this post: 

Dynamically change the information within a visual via a slicer - oxcrx34285 (powerbi.com)

Anyway, now I want to be able to switch between a visual being displayed in total and percent.

However, if I just change the display type to percent", 610 just becomes 61000% so no real solution.

The visuals affected all have a legend, what makes it even more difficult, look here:

So right now I have no idea how to display it. I can't just change the data labels to percent or load the values as %GT as in the end of the day in the report it is intended that the user just presses a button and it changes from total to percent.

Right now I have two ideas:

1. Creating a bookmark but that complicates the report structure for my successors and also everytime you change something you have to take care to change it in the bookmark too.

2. Creating calculated columns. Same: complicates the structure and adds a bunch of calculated columns as I have to do this for all my visuals so it will also affect loading time.

So maybe if there is an expression that calculates the value displayed per category, divides it through all values displayed and shows the outcome in percent, that would be what I'm looking for.

Any help would be much appreciated.

EDIT: I can't just Divide through the sum of the column as through many slicers& filters, not all values are displayed.

[MFelix · Accepted solution]

Hi @Anonymous ,

You need to use the Calculation groups to do this .

Even in live connection you can use calculation groups and create this changes, follow the step below:

• Assuming you already have Sales Measure
• On external tools execute the Tabular editor

• Rigth Click on Tables
• New Calculation Group

• Rename as you need
• Rigth click
• New Calculation Item

• Rename it sales and write the folllowing code:

SELECTEDMEASURE()

• Add two new calculation items with the formulas you have in the Power BI for the other two measures, if your measure in Power BI is for example: DIVIDE(SUM(Table[Column]), SUM(Table[Column2]) this is the formula you must place on the calculation item.
• On the Percentage formula make your formatting as %

• Save the model

• Go back to Power BI and refresh the model you should see your new table in the model
• Now create your line chart with the following setup:.
  • Axis: Column you need
  • Values: Measure Sales
  • Legend: Column from the calculated group table
• Slicer: Column from calculated group table

Check result below: