cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gaborfromungarn
Frequent Visitor

Date filter affects my tooltip page

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?

Gaborfromungarn_0-1600151942830.png

 

Thank you,

Gabor

 



2 REPLIES 2
amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors