Forum Discussion

Jack_Scallan's avatar
Jack_Scallan
Regular Visitor
3 years ago
Solved

Filter 4 table visuals by incremental months

Hi,   I have 4 table visuals. Each table displays my quantity of stock ('Table A'[Quantity]), the demand from my customers ('Table B'[Demand]) and how much stock I should have leftover which is a m...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Jack_Scallan ,

     

    Do you want to show incremental months in four table visuals ? If you want to do this, I suggest you to create an unrelated Date table to help. If you create relationship between the Date table with other tables, your visual will only show the date in slicer due to the filter.

    I suggest you to create measure filter to filter your visual in visual level filters.

    Filter1 = IF(MAX('Table'[Date]) in VALUES('Calendar'[Date]),1,0)
    Filter2 = IF(MAX('Table'[Date]) in CALENDAR(MAX('Calendar'[Date])+1,EOMONTH(MIN('Calendar'[Date]),1)),1,0)
    Filter3 = IF(MAX('Table'[Date]) in CALENDAR(EOMONTH(MAX('Calendar'[Date]),+1)+1,EOMONTH(MAX('Calendar'[Date]),2)),1,0)
    Filter4 = IF(MAX('Table'[Date]) in CALENDAR(EOMONTH(MAX('Calendar'[Date]),2)+1,EOMONTH(MIN('Calendar'[Date]),3)),1,0)

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

    If this reply still couldn't help you solve your issue, please share a sample file with me.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Jack_Scallan's avatar
Jack_Scallan
Regular Visitor
3 years ago

amitchandak thanks for your help!

 

Can you help me define what [net] should be?

 

At it appears that small multiples can not be used for the table visual.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Jack_Scallan ,

 

Do you want to show incremental months in four table visuals ? If you want to do this, I suggest you to create an unrelated Date table to help. If you create relationship between the Date table with other tables, your visual will only show the date in slicer due to the filter.

I suggest you to create measure filter to filter your visual in visual level filters.

Filter1 = IF(MAX('Table'[Date]) in VALUES('Calendar'[Date]),1,0)
Filter2 = IF(MAX('Table'[Date]) in CALENDAR(MAX('Calendar'[Date])+1,EOMONTH(MIN('Calendar'[Date]),1)),1,0)
Filter3 = IF(MAX('Table'[Date]) in CALENDAR(EOMONTH(MAX('Calendar'[Date]),+1)+1,EOMONTH(MAX('Calendar'[Date]),2)),1,0)
Filter4 = IF(MAX('Table'[Date]) in CALENDAR(EOMONTH(MAX('Calendar'[Date]),2)+1,EOMONTH(MIN('Calendar'[Date]),3)),1,0)

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

If this reply still couldn't help you solve your issue, please share a sample file with me.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.