Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I want to obtain in the power Bi desktop app the following graph but i am struggling to include the month and monthly rates on the same y axis. Could you please help me with this?
Solved! Go to Solution.
Hi @OnixOnix ,
First of all, many thanks to @lbendlin for your very quick and effective replies.
Based on my testing, it is impossible to set the monthly rates on Y axis and add a line with the quarterly values. Please try the following methods as workaround:
1.Create the simple table.
2.Create the new measure to calculate the monthly rates.
Month rate =
VAR month_val = SUMX('Table', 'Table'[Values])
VAR _tota = CALCULATE(SUM('Table'[Values]), ALL('Table'))
VAR result = DIVIDE(month_val, _tota)
RETURN
result
3.Create the new measure to calculate the quarterly values.
Quarter values = CALCULATE(SUM('Table'[Values]), ALLEXCEPT('Table', 'Table'[Quarter]))
4.Drag the two measures into the Line and column chart.
5.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @OnixOnix ,
First of all, many thanks to @lbendlin for your very quick and effective replies.
Based on my testing, it is impossible to set the monthly rates on Y axis and add a line with the quarterly values. Please try the following methods as workaround:
1.Create the simple table.
2.Create the new measure to calculate the monthly rates.
Month rate =
VAR month_val = SUMX('Table', 'Table'[Values])
VAR _tota = CALCULATE(SUM('Table'[Values]), ALL('Table'))
VAR result = DIVIDE(month_val, _tota)
RETURN
result
3.Create the new measure to calculate the quarterly values.
Quarter values = CALCULATE(SUM('Table'[Values]), ALLEXCEPT('Table', 'Table'[Quarter]))
4.Drag the two measures into the Line and column chart.
5.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Thnak you for your response.
This goes against UX guidelines. What would be the business benefit of such a display?
User | Count |
---|---|
86 | |
84 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |