Forum Discussion

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago
Solved

Create Pareto Chart with ABC Classes

https://drive.google.com/file/d/1o1N4ITwkm5zamrv6rt_q5LQocI9nzOhK/view?usp=sharing 

 

Hello:

 

I'm hoping to create a differentiated Pareto Sales Chart where I have broken items (in product table) into A, B & C classifcations with a calculated column. 

I have inserted an image of what I want to chart to look like right on the report. All the premliminary calculations have been done, I beleive in Chart Measures folder. 

 

Can anyone give me input on how to create this chart, keeping a different color for each item classifacation?

 

I have attached my file.

 

Thanks much! 

Need Help
Show and Tell
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Whitewater100 ,

     

    I add a column named [Rank %] in your pbix file and result:

    Rank % =
100 * RANKX( 'Products', [Sales %],, ASC )
    / COUNTROWS( 'Products' )

    You can refer the pbix in the end

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

     

     

     

6 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    I am not sure whether i can get your desired chart or not.  However, what i can help you with is reducing the number of measures you have written and doing away with calculated columns.  The calculated column formula that you have written in the Products table is not a good practise these formulas do not respond to a change in slicers/filters.  So let me know if you are interested in my proposal.  If I can successfully implement my solution, may be we can get the chart you want but i am not sure.

    • Whitewater100's avatar
      Whitewater100
      Icon for Solution Sage rankSolution Sage
      4 years ago

      Hi Ashish:

       

      thanks for replying. I added in four new CC to arrive at ABC.  I'm always interested to learn if there is a better way. So I will stay tuned.

       

      However, I could really use the help on making the visual. Any input is appreciated.

       

      Thanks!

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Whitewater100 ,

     

    I add a column named [Rank %] in your pbix file and result:

    Rank % =
100 * RANKX( 'Products', [Sales %],, ASC )
    / COUNTROWS( 'Products' )

    You can refer the pbix in the end

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

     

     

     

    • Whitewater100's avatar
      Whitewater100
      Icon for Solution Sage rankSolution Sage
      4 years ago

      Hello:

       

      Thank you very much for your follow thru and help on my question. I really appreicate that! Have a nice day.