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
Hi,
I have created a table with values in it by year-month.
I have also created a tooltip. The tooltip contains 2 charts.
1: a small table with the change
2: a small linechart with year-month in the X axis
At the moment the Year month on the report page is filtering the line chart for 1 year-month.
Is it possible to stop that from happening somehow?
Thank you,
Gabor
@Gaborfromungarn , In this you can either use all YTD measure or a measure that ignore dates
Example
Calculate([measure], all(date))
But as the filter has been passed you might need an independent table to plot trend: https://www.youtube.com/watch?v=duMSovyosXE
Hi @amitchandak
That is a brilliant idea, but I don't really want to create another table, as it would increase the size of the model, by almsot double.
Gabor
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 67 | |
| 62 |