Power BI Dashboard - Source file format

Question

Hi! I been using Power BI for last couple of months. When I start to create dashboard in Power BI for one of the table format I was not able to fix the issue. It would be very helpful I you could help me in the issue.

Attached are two images. One image showing Dashboard whereas the other is the excel table format.

I would like to create a dashboard as attached without changing the table format. Is it possible?

Thanks,

Nivash

v-piga-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
If I understand your requirement correctly that you want to create the clustered column chart in power bi based on the data table like the second image?
If it is, could you share your data sample with table format so that we could copy and test on it?
Best&nbsp; Regards,
Cherry
&nbsp;

parry2k · Answer

Anonymous your question is not fully clear, can you please elaborate bit more.

anonymous · Answer

Hi!&nbsp;Thanks for your reply.&nbsp;Thats what exactly I mean.&nbsp;Below is the link for excel file format with the graph. I would like to create the chart in power BI without changing the table format.https://entuedu-my.sharepoint.com/:x:/g/personal/srinivas010_e_ntu_edu_sg/EQbvBJxT8mpLjb0GXec9O2UBQb62ZEM6V1IaglQL1dmttA?e=EaPeZuThanks

v-piga-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
For your table format, I'm afraid that we cannot create that chart in power bi.
As a workaround, you could duplicate the original table and then Unpivot the date columns for the table 2 in query editor so that you could get the date column as the x axis for the clustered column chart.

In addition, I have a little confused about the Sales 14 and Sales 13, it seems that there is no column named&nbsp;Sales 14 and Sales 13 in your table format.
Best&nbsp; Regards,
Cherry
&nbsp;
&nbsp;