Forum Discussion
DAX
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.
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
I have to show entire month date wise in a graph when I select a month in slicer.
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.⚡
