Calculate Gross Sales for 4-5 sites and show it in clustered bar chart

[Vedvati]

Hello,

I am new to Power BI.

I have written function to get the data from multiple tables in SQL.

Now I want to calculate Gross sales for 4-5 sites for This year and Past year and show that in clustered bar chart.

X-axis -> Sites Names

Value -> Gross Sales

Legend -> Year

This is what I am thinking of.

How can I achive that?

Kindly let me know if any other work around is there.

Thank you.

[v-piga-msft · Accepted solution]

Hi @Vedvati ,

Based on your dedcription, I still have a little confused about your scenario.

If it is convenient, could you share the data sample which could reproduce the scenario and your desired output so that we could help further on it.

Please refer to this article about how to get your question answered quickly.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Vedvati ,

Based on your dedcription, I still have a little confused about your scenario.

If it is convenient, could you share the data sample which could reproduce the scenario and your desired output so that we could help further on it.

Please refer to this article about how to get your question answered quickly.

Best Regards,

Cherry

[Vedvati]

Hello,

Could you just help me out on this:

I have a slicer to select Date Range. I want to show data from previous year for same date range.

So how to get the selected dates in DAX?

Thank you in advance.

[v-piga-msft · Accepted solution]

Hi @Vedvati ,

Normally,if we want to get the date you selected in slicer, you could use  SELECTEDVALUE with DAX.

If you have the date between slicer, you could use MAX and MIN function to get the date range in between slicer.

Best  Regards,

Cherry