DAX

[Anonymous]

how to show entire month sales in a graph or table when I select a month in a slicer?

[amitchandak]

@Anonymous , when you filter a month from slicer you will get that month data. What you want to achieve here.

[Anonymous]

but I want entire month date wise in a graph when select a month in a slicer

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Please refer to my sample.

I have a table like this.

Then I create a [Month] column.

Month = [Date].[Month]

 

At last, add the fields into the visuals.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

So take a date(day wise) in the x-axis and any metrics column in the y-axis of any Line or bar chart. 

Then if you select any month from slicer so the chart will get filtered out based on that.

[Tahreem24]

@Anonymous ,

Please share the complete requirement with input and expected output. 

[Pragati11]

Hi @Anonymous ,

You can bar chart to visualise such requirement by putting Date (month-year) to x-axis and your total sales to y-axis.

In order to answer you query in a better way, you will need to provide additional details. Please refer following link to see how to get your query answer correctly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Thanks,

Pragati

[Anonymous]

I have to show entire month date wise in a graph when I select a month in slicer.

[parry2k]

@Anonymous As a best practice, add date dimension in your model and use it for and time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools.

https://perytus.com/2020/05/22/create-a-basic-date-table-in-your-data-model-for-time-intelligence-calculations/

Use date on x-axis from date dimension and sum of amount or sales on y-axis, put month from date table on a slicer. On the selection of a month, you will see the dates from the selected month.

PS-Always add and use date dimension in your model when working with time intelligence

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡