Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Pie Chart based on Measure Results

I have multiple measures I am using to visually show the "health" of a project.

 

Example:

Finance KPI Indicator Color = if([Total Actual & Forecast]<[Total Budget], 1, if([Total Actual & Forecast]>1.1*[Total Budget], 0, if([Total Actual & Forecast]<1.1*[Total Budget], 2, 3)))
 
 
I would like to create a pie chart than can show how many "Red/Yellow/Greens (which are conditionally formatted based on the numbers above)" I have, but I don't seem to be able to create pie charts based on measures.
 
Am I missing something?
Need Help

5 Replies

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    We can create a pie chart using three measures to meet your requirement.

     

    Red = COUNTX(FILTER('Table',[Finance KPI Indicator Color]=0),[Finance KPI Indicator Color])

     

    Green = COUNTX(FILTER('Table',[Finance KPI Indicator Color]=2),[Finance KPI Indicator Color])

     

    Yellow = COUNTX(FILTER('Table',[Finance KPI Indicator Color]=1),[Finance KPI Indicator Color])

     

     

    If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?

    It will be helpful if you can show us the exact expected result based on the tables.

     

    Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    BTW, pbix as attached.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I tried this and thought it was going to work perfect - but the counts that it is getting are COMPLETELY off

      • v-zhenbw-msft's avatar
        v-zhenbw-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous ,

         

        Could you please provide a mockup sample based on fake data?
        It will be helpful if you can show us the exact expected result based on the tables.
         
        Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.
         

        Best regards,

         

        Community Support Team _ zhenbw

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    How about the result after you follow the suggestions mentioned in my original post?

    Could you please provide more details or expected result about it If it doesn't meet your requirement?

    If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I am about to ask the same question. I have a measure which gives me the percentage of panels that need a healthcheck which I have put in a matrix. What I am hoping to achieve is to count the values of each percentage and have them in a pie chart.

     

    The pie chart will show that for example 23% of companies have 100%, 5% of companies has 93% and so forth.

     

    The measure I use is two count measures one counts the amount of panels the company has and the other counts how many of these panels have healthchecks scheduled in the future. Both of these results are also on the matrix result set below.

     

    Is this at all possible?