Forum Discussion
Need help for dashboard
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!
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.
4 Replies
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.
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)
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.
