Visual help!

[Anonymous]

Hi all

I don't know how to achieve this goal. Below is my data sample

product	phase1	phase2	phase3	phase4
A	1	1	1	2020-12-1
B	1	2020-10-30	2020-10-5	2020-12-12
C	1	1	1	1

How can I achieve result like below in powerbi vsiaul

Thank you for your help

[Anonymous]

@Anonymous 

Can you elaborate? What doest the blue arrows mean? You can post a expected output table.

Regards
Paul

[Fowmy]

@Anonymous 

In Power Query, Select the Product column and choose UnPivot Other Columns. Now you will have just two columns. Filter the 2nd column to only ones. This will help you create a bar chart.

Let me know if you need any help on this.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Hi @Fowmy ,

Thank you for your help, but I need to show phase 1, phase 2 in X axis, and I also need to show 2020-1-1 in chart.

[Fowmy]

@Anonymous 

Not very clear about your requirements

Can you provide more details and the expected output with sample data?

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn