Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi dear community,
I am trying to create a clustered line chart visual as shown below.
Here I want to show APP and WEB as percentages, for example for the month of april APP has 40M and WEB has 65M. I want these values to be shown in percentages. In this case, APP should show 38% and WEB 62% and so on for the following months.
Can someone help me achieve this?
Hi @sbadiger3
Go to column Y-Axis and select percent of grand total instead of no calculation at the botton under show value as shown in below screenshot. This should show the contribution of each product in percentage.
Hi @sbadiger3,
Create the measure below
Percentage of Total =
FORMAT (
DIVIDE (
[Measure],
CALCULATE ( [Measure], ALLSELECTED ( 'Table'[App/Web Column] ) )
),
"0%"
)
In the data labels option, enable Custom label and drag the measure above to the field tile. I used the May 2023 version of Power BI. If custom label is not available, please update your version. If still not available, it may be a preview feature so enable it first. The display units and decimal options are irrelevant as the format has been hardcoded in the measure. Note that I had to do so as there's no option to show the measure as % although measure format is already set as such.
Please see sample screenshot below:
Proud to be a Super User!
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |