Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Chris2038
Frequent Visitor

Dynamic table - KPIs using dates as headers

I have created a few measures that need to be displayed in tabular format. See below an example. This was done in excel with the user selecting a date, the intervals, and the smoothing period. In the example below, the user selected 12/31/21 and an interval of 1 month to get that table. 

 

I would like the table to have no more than 7 columns as shown below.

 

Chris2038_0-1642653015738.png

 

Any suggestions or guidance is highly appreciated. 

 

2 REPLIES 2
Chris2038
Frequent Visitor

Thanks for the reply. I understand the show measure on row feature, however, how do I get a range of dates (based on, lets say top N) as columns?  For example, assume I select Dec 31 as my date, and I want the top 7 dates (by descending order) assuming an interval of 1. There would be 12/31/21 as a first column, and then 11/30/21 as second column, etc etc.

Chris2038_0-1646441329076.png

 

amitchandak
Super User
Super User

@Chris2038 , These measure on row( Using show on row in Matrix) and you can control 7 day range using date slicer or an independent date table

 

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.