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.
Hello the community,
Sorry if my message has already been posted, but I am pretty sure you will find the answer quickly
Here my data :
Here the result and until here everything is fine:
What I want to do is to add a simple total column like under excel :
I already found a trick by duplicating the chart and then removing the range value.
And then to finish trying to connect the two graphics as well as possible
but I don't find this solution very convenient.
Do you have other tricks please ?
Many thanks,
Pierre
Solved! Go to Solution.
@PierreL69 solution attached, here are the steps:
- unpivot your original table in power query
- create new range table from original table and added a Total row
- create relationship between two tables on Range
- add measure to check if Total then add all values otherwise simple sum
- on visual, use Range on x-axis from new table called Range and on value use measure and legend is Type
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@PierreL69 solution attached, here are the steps:
- unpivot your original table in power query
- create new range table from original table and added a Total row
- create relationship between two tables on Range
- add measure to check if Total then add all values otherwise simple sum
- on visual, use Range on x-axis from new table called Range and on value use measure and legend is Type
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thank you very much !
The final result is perfect, much more better than my trick
But is this the easiest solution to generate a total?
Because I still find it not very intuitive when you have limited knowledge about Power BI
I was hoping there would be a simple button or option to add this total.
In any case, a big thank you
@PierreL69 nothing like adding by click of button afaik.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi, it is me again,
I just would like to understand why did you use the Max function to find the total?
Because max function work usually with numbers if I am not wrong?
Thanks for your help
@PierreL69 it doesn't need to be MAX, it can be MIN, basically we need to use an aggregated function to get the value of ouur Range column, since it is a measure, we cannot use column directly so that's the reason I used MAX. Hope it helps. let me know if you have further question.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I am still a little bit confused.
For example if I replace Max by the Average formula, it could also work?
The idea is to use a formula (so an aggregated function), that return one value and to compare it to the value we are looking for
Thanks
Ok thanks for the info,
Now I know the way to do it 🙂
This is the important thing
thanks
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |