Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello PowerBI Community!
I really need help with creating this additional visualization that I was stuck with for quite a long time.
Here is a mock-up dataset: (Column A has all 7 days)
Column A | Column B | Column C |
Monday | John | 200 |
Tuesday | Steve | 400 |
Monday | Clive | 600 |
Tuesday | Austin | 1000 |
Tuesday | John | 900 |
Saturday | Clive | 1100 |
Monday | John | 1200 |
What I did was to create a Card Visualization that shows the total count of column C as well as 2 different filter slicers that gives me a list of the 7 days in a week and a list of the individuals in the dataset.
What I need to do is to create a pie/donut chart as well as a percent value (something like a card) that shows the proportion of column C's value when I click on the list in my filter slicer.
For example, if I clicked on Monday, it will give me a total of (200+600+1200/Total of Column C) = 37%.
If I clicked on Monday & John, it will give me (200+1200/Total of Column C) = 26%.
The pie/donut chart will 37% of it shaded in another color.
I really appreciate any help! Thank you so much !!
Solved! Go to Solution.
@lwklwk98
Pie or Donut chart will not show the shaded area in another color. you can use the Guage chart effectively
Measure:
Percent =
DIVIDE(
SUM(Table6[Column C]),
CALCULATE(
SUM(Table6[Column C]),
REMOVEFILTERS(table6)
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@lwklwk98
Pie or Donut chart will not show the shaded area in another color. you can use the Guage chart effectively
Measure:
Percent =
DIVIDE(
SUM(Table6[Column C]),
CALCULATE(
SUM(Table6[Column C]),
REMOVEFILTERS(table6)
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you so much! The Guage Chart is the perfect icing on the cake 🙂
Hi @lwklwk98 ,
You can create a measure like this to get the desired result:
Proportion% = DIVIDE(sum('Table'[Column C]),CALCULATE(sum('Table'[Column C]),ALL('Table')),BLANK())
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Thank you so much! I have learned something from you!
@lwklwk98 , Try a measure like
divide(sum(Table[Columnc]), calculate(sum(Table[Columnc]), all(Table)))
or
divide(sum(Table[Columnc]), calculate(sum(Table[Columnc]), allselected(Table)))
Thank you so much! That is easy to understand.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |