Forum Discussion

Juju123's avatar
Juju123
Helper III
2 years ago

Table with different time dimensions

Hello 🙂 ,

I would like to know if it is possible to create this type of table in Power BI.

I have a reference date which is today's date.

 

The user will have the possibility to modify the reference date, depending on the date he has chosen,

 

I wish:

  • Show dates lower than this reference date
  • Display the 12 months rolling in relation to this date
  • Display the last 5 in relation to the date selected. Do you have any idea how I could make this table in Power BI. The numbers in the table are an indicator.

Thanks for your help 🙂 

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Sure it's possible but you are looking at creating a truckload of measures. Consider using separate visuals.