topic daily slicer shows monthly chart in DAX Commands and Tips

daily slicer shows monthly chart

Anonymous — Mon, 18 Jan 2021 21:03:29 GMT

Hello community,

I need to create a chart with all the values for the month, but my slicer needs to be daily, as I have other views.

Example:
When selecting 2021/01/18, I need all values for the month of January to appear.

It's possible?

Re: daily slicer shows monthly chart

nandic — Tue, 19 Jan 2021 00:05:45 GMT

Hi,
You could use disconnected table in this case.
For this purpose you will need date table which has no relationships to other tables, so it is "disconnected".
Here are some nice examples: https://www.bluegranite.com/blog/disconnected-table-power-bi

Regards,
Nemanja Andic