Forum Discussion

Gerbil's avatar
Gerbil
Helper I
2 years ago

Creating a Line Graph with Percentiles

I have a dataset that looks like this:

 

And in Excel, you can calculate the percentiles then create a graph that looks like this:

 

Is there a good way to go about this in Power BI? Or do I have to create a measure for each quartile and compile them all together? I ask because I need to create three of these graphs, with three different datasets and each column is actually a measure (sum by ID). So I would end up with 27 measures just to create three graphs (each quartile needs a measure, each value column needs a measure)

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Gerbil 

     

    amitchandak Thank you very much for your prompt reply.

     

    Can you tell me if your problem is solved? If yes, please accept it as solution.

     

    If you still have problems, it is best to provide the pbix file and be careful to delete sensitive data.

     

    Regards,

    Nono Chen