Need help for dashboard

[jun_9644]

Hi. I have data sets which look like this. I am trying to compare the revenue of the same outlet but in different periods. However, Power BI is unable to show each quarter and revenue distinctively, instead the data are lumped together. When I filter by outlet A and only pick Qtr 1 and 2, there is only 1 bar chart and it shows the sum of Qtr 1 and Qtr 2. May I know how should I approach this? Thank you!

[Jihwan_Kim]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

[jun_9644]

Hi! Thank you so much for the reply. However, is it possible to have qtr 1 and 2 be in a stacked bar chart? (for comparison purpose)

[Jihwan_Kim · Accepted solution]

Hi,

Thank you for your message, and please check the below picture and the attached pbix file.

You can try to change the visualization to Stacked Barchart, and put the Period column to the Legend area.

[jun_9644]

Thank you for your reply! Just want to check if I want to visualise the variance between Qtr 1 and 2 on a card, how should I do it?