Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Greetings,
I'm trying to show a line graph with a time period as x Axis and I wan't every time period to amount to 100%. I see that this is possible by using a slicer for the time period. Example of the data that I want to show:
And this is the line graph that I currently have, can I adjust it so that every time period amounts to 100%?:
Solved! Go to Solution.
I guess that you're showing the "Percentage of grand total"?
If so, to show as you expected, you'll have to create some measure as below. See more details in the attached pbix file.
percentage = DIVIDE(sum(Table5[sales]),CALCULATE(SUM(Table5[sales]),ALLEXCEPT(Table5,Table5[date])))
Hello, i have similar problem but i can't seem to get the line graph to total each month at 100%.
Below chart totals 100% across all 4 months. I need each month to total 100%.
I need the line to total to 100% for every month. I have the formula like this
I guess that you're showing the "Percentage of grand total"?
If so, to show as you expected, you'll have to create some measure as below. See more details in the attached pbix file.
percentage = DIVIDE(sum(Table5[sales]),CALCULATE(SUM(Table5[sales]),ALLEXCEPT(Table5,Table5[date])))
Dear Eric,
Thank you for sharing how to show a line graph that uses 100% everytime.
Now my question to you is how to make this equation more dynamic, so that it takes into account the data hierarchy and date filters.
I am interested in a calculation that is by months. When I use your equation it only works when I use the date at the lowest level (by the day). I am interested in it being 100% per month. Additionally, I would like to take into account that there are different months in a year that could be flexible when date filters are used.
Anyone can solve this problem, show line graph that uses 100% every month period?
Thank you a ton, yesterday I ended up finding this measure to solve my problems but your file will help me greatly in the future.
Yesterday I ended up with the following measure and it seemed to work:
% Van respondenten = DIVIDE(COUNTA('TABLE'[Response]); CALCULATE(COUNTA('Table'[Response); ALLEXCEPT('Table';'Table'[Time column]));0 )