Forum Discussion

jmeccles's avatar
jmeccles
Icon for Helper I rankHelper I
9 years ago
Solved

Percentage Calculation based on Slicer

Hello, everyone! I have a problem which I believe is very easy to solve; however, ...I haven't been able to so, I'm asking for your help. Below, I have a table of values:   ID Pattern Ye...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    In your "Count of ID" in your Values area, click the drop down and then Show as: Percent of Grand Total. Filter your visualization to get rid of M. You should have what you want.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

In your "Count of ID" in your Values area, click the drop down and then Show as: Percent of Grand Total. Filter your visualization to get rid of M. You should have what you want.

  • jmeccles's avatar
    jmeccles
    Icon for Helper I rankHelper I
    9 years ago

    Thanks, Greg_Deckler! It's simple and it works, just as I suspected.

    And thank you Anonymous. Your solution taught me a few things about the creation and use of variables in Power BI but it just wasn't what I was looking for.