Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
Juju123
Helper III
Helper III

Table with different time dimensions

‎09-19-2023 02:30 AM

Hello 🙂 ,

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

Juju123_0-1695115701219.png

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 🙂 

Message 1 of 2
515 Views
0
1 REPLY 1
lbendlin
Super User
Super User

‎10-14-2023 11:31 AM

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

Message 2 of 2
432 Views
0

Helpful resources

Announcements
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All