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