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

Hide graph when no data is selected

I have a table of data containing site locations, and a related line graph showing environmental times series data belonging to that site. When I select a row in the table, the line graph shows the related data. (perfect!)

However when no site is highlighted the graph aggregates the data and shows the sum. This is misleading and incorrect.

How do I show a blank graph when nothing is selected in the table?

1 ACCEPTED SOLUTION

Accepted Solutions
Nishantjain Member
Member

Re: Hide graph when no data is selected

Have you tried using this measure

 

replace the [Your measure] in the code below with the current measure that you are using in the line graph

 

 

if(isfiltered([Site Name]),[Your measure], blank())

 

 

When you use blank(), it returns no values and should leave your graph blank

 

Hope this helps

Nishant

 

View solution in original post

3 REPLIES 3
kiwipeet Frequent Visitor
Frequent Visitor

Re: Hide graph when no data is selected

More:

I've created a measure which can detect when a row is selected:
SlicerCheck = if(calculate(distinctcount([Site Name]),allselected('TakeStatus'[Site Name]))=1,"Y","N")

But how can I filter or hide data based on this?

Nishantjain Member
Member

Re: Hide graph when no data is selected

Have you tried using this measure

 

replace the [Your measure] in the code below with the current measure that you are using in the line graph

 

 

if(isfiltered([Site Name]),[Your measure], blank())

 

 

When you use blank(), it returns no values and should leave your graph blank

 

Hope this helps

Nishant

 

View solution in original post

kiwipeet Frequent Visitor
Frequent Visitor

Re: Hide graph when no data is selected

Hi. Thanks for replying. I got it working... Something along the lines of what you are suggesting. Ive marked your answer as correct.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Kudoed Authors (Last 30 Days)