Forum Discussion

enterprised1's avatar
enterprised1
Helper I
9 years ago
Solved

Display Percent rather than Count

Hi,   This seems like a simple thing to do in theory, but I can't seem to make it happen in Power BI.  If anybody has any suggestions, it would be greatly appreciated!  Here's the scenario:   I ...
  • v-micsh-msft's avatar
    v-micsh-msft
    9 years ago

    Hi enterprised1,

     

    We should write measure to show the correct percentage. Please follow the steps below to see if it would work:

    1. Under the data View, create a measure to calculate the count of Amount=800;
    2. Count800 = calculate(count(‘Table’[ID]), ‘Table’[Amount]=800)
    3. Create another measure to calculate the percentage:
    4. Precent = Divide([Count800],COUNT(‘Table’[ID]))
    5. Under the report View, in the Fields, click Precent, then click on % to format it. Select Card Visual and put the Precent into the values, it should show the correct percentage:

    Using the quick calc here would always show 100%, as the total count is also filtered, but not the original total.

    If any further help needed, please feel free to post back.

    Regards

v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

Hi enterprised1,

 

We should write measure to show the correct percentage. Please follow the steps below to see if it would work:

  1. Under the data View, create a measure to calculate the count of Amount=800;
  2. Count800 = calculate(count(‘Table’[ID]), ‘Table’[Amount]=800)
  3. Create another measure to calculate the percentage:
  4. Precent = Divide([Count800],COUNT(‘Table’[ID]))
  5. Under the report View, in the Fields, click Precent, then click on % to format it. Select Card Visual and put the Precent into the values, it should show the correct percentage:

Using the quick calc here would always show 100%, as the total count is also filtered, but not the original total.

If any further help needed, please feel free to post back.

Regards

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have specified the column is a percent in the data table but it is showing as a decimal in the card. And under modeling the formatting options are grayed out, do you know why that would be?