Forum Discussion

mmainza's avatar
mmainza
Frequent Visitor
8 years ago
Solved

Make visual blank/display instructions until other visual selected to filter

Caught this report used by a journalist to track FRPL over time in New York.   Notice how the timeseries visual is not only blank until the other visual is selected to filter, but it displays promi...
Show and Tell
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi mmainza,

     

    I created a sample pbix file for your reference. :smileyhappy:

     

    Mainly, you'll need to use ISFILTERED function create two measures.

    Show Text = IF(ISFILTERED(Products[Category]),"","Select a category in chart above to see its trend!")
    Show Sales = IF(ISFILTERED(Products[Category]),[Total Sales])

    Then show [Show Text] on the Card visual(with Category Label Off).

     

    And show [Show Sales] on the Line Chart.

     

     

    Regards

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

Thanks for that

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Pmorg73  Your file helps me to explain my issue. In your file, in the Table visual you inserted Card on top of the table and the size of the card is smaller. If you increase the size of the Card to the size of the Table and select something in the slicer, then you will get the values filtered in the table. But when you hover on those filtered values, you will lose the clickability. 

     

    In my case I have an URL in the table and because of inserting card on top of the table I am not able to click on the URL's I have. 

     

    Also can I know how you got that empty table before selection and how you are getting the filetred values from the empty table when something is selected?

  • Pmorg73's avatar
    Pmorg73
    Post Patron
    6 years ago

    I will try to explain what I did. aMd if you follow in the file I uploaded it shoudl hopefully make sense.

     

    To start with my table orginally had the values for "Time Est Sum". This was a measure that simply "sum" of: 

    Time Est Sum = sum('07_Workflow Time Report'[Time estimated calc])

    This value would not mask at all and would return the total values until something was selected.

     

    BTW

    The Time Est calc is a column added for the table as my data exports time in an hour format, so I had to use the following to make it decimal:

    Time estimated calc = 24 * '07_Workflow Time Report'[[Task]] Allocated Time] -24
     
    What I did next to solve this was make a new measure which you will see called "Time Est". This uses this thread to filter with the slicer as follows:
    Time Est = if(isfiltered('02_Job List'[[Job]] Job Summary]),CALCULATE('07_Workflow Time Report'[Time Est Sum]))
     
    So in summary in my case. I started with values. Added a column to adjust the value to decimal (you would not need this). This was my original table. I then Made a measure to sum this value which basically returned the same value that I already had. I added another measure to "isfiltered" the measure.
    It does not work with just the value column, I could only select the measure one I created that. 
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Pmorg73  Here I inserted two images from your file. 

    • In the first one I just selected one value from the slicer(from your file) and when I hover over those filtered values I am able to see that particular value(Job Administration) as a tool tip. 
    • In the second case I increased the size of a Card which you inserted on the top of table. I made card size equal to the size of table. Now when I select any values from the filter and hover over those filtered values, I am not able to see the tool tip like the previous one(Job Administration) because of Card on top of the table. 

    In my case I have a column which contains URL's and I want to click on that URL. But this card is stopping from being able to click on that. Hope you better understand my scenario now.

     

     
     
     
  • Pmorg73's avatar
    Pmorg73
    Post Patron
    6 years ago

    Alas I have only been using Power BI for 3 months and do not know the answer and have never used URL's in my tables.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

    Pmorg73  Okay, Thank you for your support till this point.