Creating a Line Graph with Percentiles

[Gerbil]

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)

[Anonymous]

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

[amitchandak]

@Gerbil , I am assuming Quarter is on rows. Unpivot the data to have years on the row.

Then you can have Year on Axis and Quarter as legend 

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g