Forum Discussion

jun_9644's avatar
jun_9644
Regular Visitor
2 years ago
Solved

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 distincti...
Need Help
Show and Tell
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    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.

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
2 years ago

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's avatar
jun_9644
Regular Visitor
2 years ago

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's avatar
    Jihwan_Kim
    Super User
    2 years ago

    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's avatar
      jun_9644
      Regular Visitor
      2 years ago

      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?