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

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.