Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Header Column in a table visual

Hello everyone ! Could you please help me with the following doubt.

 

How do I select the Month name in the table, where If I select the month is january, the next column should display me the months after january and in that quarter. 

The data should be displayed as 

If I select the Jan 

Jan Feb March Quarter1 
If I select April

April May June Quarter2 

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Prefer to use an independent date table for slicer and this measure will cover remaining months

     

    measure =

    var _min = minx(allselected('Date1'), Date1[Date])
    var _max = maxx(allselected('Date1'),endofquarter( Date1[Date]))
    return
    calculate(Sum('Table'[Value]), filter('Date', 'Date'[Date] <=_max && 'Date'[Date] >=_min ))

     

    on matrix column, you can have a month with column grand total

     

    Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

2 Replies