Forum Discussion
DAX
how to show entire month sales in a graph or table when I select a month in a slicer?
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
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 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.⚡
Anonymous , when you filter a month from slicer you will get that month data. What you want to achieve here.
Anonymous ,
Please share the complete requirement with input and expected output.
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.
