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
Hello,
I'm trying to create a Table visualization that has "live" value titles. The titles right now say "Current Month", "Current Month minus One", "Current Month minus Two", etc. but I would prefer if the titles actually listed the month. The months will obviously change as the months change because I'm only looking for the last 6 months, but I would like it to read "May", "April", "March" etc but keep current to whatever the last 6 months were.
Thanks!
@dtango9 , refer if this can help
https://www.blue-granite.com/blog/create-a-dynamic-title-in-power-bi-updated
Hi @dtango9,
Just an idea, Probably unpivot your data,
sort by Month,
and always take the recent 6 months columns,
Pivot your data again and use Table visual.
Thanks,
Sunil.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 90 | |
| 78 | |
| 66 | |
| 65 |