Forum Discussion

ramanathans's avatar
ramanathans
Frequent Visitor
5 years ago

Ability to expand selectively on column headers

Is it possible to expand specific column headers. In case of row headers we can use +/- to expand and collapse specific elements. I would like to do something similar for columns.   I understand th...
Need Help
Show and Tell
Tutorial Requests
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago

ramanathans The only other option I can think of besides those you have mentioned is to write measure specific to the columns you are trying to display. So if you wanted to show 5 columns like

  • Sales This Week
  • Sales Last Week
  • Orders This Week
  • Orders Last Week
  • Total Customers

You would write measure to give you the specific time period you are looking for. 

Sales This Week = 
CALCULATE (
    SUM ( Sales[Amount] ),
    DATESBETWEEN ( Dates[Date], TODAY () - 6, TODAY () )
)
Sales Last Week =
CALCULATE (
    SUM ( Sales[Amount] ),
    DATEADD ( DATESBETWEEN ( Dates[Date], TODAY () - 6, TODAY () ), -7, DAY )
)