Forum Discussion

Vivdroid_C_4222's avatar
Vivdroid_C_4222
Frequent Visitor
1 year ago
Solved

Help! How do I show MTD dates in Table Visual.

I have a date slicer, and the slicer type is set to "before" to show only the end date. I have a table visual where I have added dates in columns. Now if I select 6 june 2025 in slicer, I want ...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi Vivdroid_C_4222,

    Thank you for the update. Could you please share the sample data related to your thread? This would help me reproduce the scenario and work towards a solution. Please provide the sample data in table format, along with the expected outcome based on your thread.

    Thank you.

RicoZhou's avatar
RicoZhou
Frequent Visitor
1 year ago

Hi Vivdroid_C_4222,

 

No need an unrelated date table. You can try to add a measure filter to filter your table visual.

My Sample Table:

Relationship:

Measure:

Measure Filter = 
VAR _MONTHSTART = EOMONTH(MAX(DimDate[Date]),-1)+1
RETURN
IF(MAX('Table'[Date]) >= _MONTHSTART,1,0)

Add this measure into visual level filter and set it to show items when value = 1.

 

Best Regards,

Rico Zhou