Column Chart - Keep Year and Month of Date slicer but ignore day selection

[HankScorpio2]

I want the user to have the ability to see daily information on the page. However, I want to have a column charts that shows the monthly trends daily. Thereby allowing them to get a handle on the monthly perspective while viewing daily data.

My page has a Year, Month, Day slicer. I want the column chart to show the daily volumes for the month. 

Currently if the user selects a day in the slicer the chart filters to that day. Is there a way to ignore the day from the selection but retain the other date objects the user has selected?

Thanks,

[v-tejrama]

Hi @HankScorpio2,

I would also take a moment to thank @maruthisp and @Irwan  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please Accept it as a solution so that other community members can find it easily.

[maruthisp · Accepted solution]

Hi HankScorpio2,

As per my understanding, you can override slicer filters using REMOVEFILTERS or ALL in your DAX measure.

Sales_Daily_IgnoreDay =
CALCULATE(
SUM(SalesData[SalesAmount]),
REMOVEFILTERS('Date'[Day])
)
This keeps the Year and Month filters but ignores the Day filter from the slicer.

You can show daily sales trends for a selected month even if a user picks a specific day by ignoring the day filter in your DAX measure. This gives users a full monthly view while still allowing detailed daily exploration elsewhere on the page.

Please let me know if there is any questions.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[lbendlin]

My page has a Year, Month, Day slicer

Get rid of all slicers.  Put the date in the X axis of the Column chart.  Let the chart do the hierarchy for you.

[Irwan]

hello @HankScorpio2 

how about to disable the interaction between day slicer to column chart and column chart to day slicer?

disable interaction will remove ability to filter each other between those two table.

Thank you.,