Forum Discussion

lwklwk98's avatar
lwklwk98
Icon for Helper I rankHelper I
5 years ago
Solved

Visualization Help - Show Proportions in Pie Chart & Percent Value

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)   ...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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)
    )
)

     

jaideepnema's avatar
jaideepnema
Icon for Solution Sage rankSolution Sage
5 years ago

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 ğŸ˜€

 

lwklwk98's avatar
lwklwk98
Icon for Helper I rankHelper I
5 years ago

Thank you so much! I have learned something from you!