Power BI graph not show same with Excel graph

[fastspeed33_BI]

Hello, I am the beginner of Power BI, Would like to ask the graph question.

In the excel shows month together for each valueX

But for the same data in Power BI

The Value1 and Value2 show together for each month

Anyway to show the same with excel ?

[SpartaBI]

@fastspeed33_BI 

Here is a link to download a sample solution file:
Power BI graph not show same with Excel graph 2022-08-10.pbix

Showcase Report – Contoso By SpartaBI



      

[ChristianDGreat]

Actually this is possible but need some modification. 
Is the excel version is the one you really want to mimic?

[fastspeed33_BI]

Yes, it is.... 🙂

[ChristianDGreat]

Are you looking to have the month right here as well?

[fastspeed33_BI]

Actually, no need, only group month 1 and 2 together for each ValueX

[v-jingzhang · Accepted solution]

Hi @fastspeed33_BI 

In Power BI, you need to modify the structure of the table to make it fit for the column chart. You can use Power Query Editor to do that. Below are my steps. 

1. Open Power Query Editor from Home > Transform data. 

2. Select Value1 and Value2 columns at the same time. Unpivot them from Transform > Unpivot Columns. 

3. Close Power Query Editor and apply the change to Power BI Desktop. 

4. When creating a column chart, add Attribute to X-axis, add Value to Y-axis and add Month to Legend. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.