Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Any suggestions or guidance is highly appreciated.
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 , 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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 133 | |
| 88 | |
| 85 | |
| 68 | |
| 64 |