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

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
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

mmainza's avatar
mmainza
Frequent Visitor
8 years ago

Perfect!

 

Now I have the excuse to play around with ISFILTERED. Thank you!

 

Separate question - is there a way to control hover interactions between visuals? For example, in Tableau you can set whether a viz hovers on top or behind the others? Currently, my card viz gets hidden by the line viz. Other times it doesn't, but I can't figure out why it works when it works.

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    6 years ago

    mmainza 

     

    Not sure what you mean by "hovers on top or behind", but you can determine where each visual lies (layering) using the "Bring foward" or "Send backward" in the format ribbon. 

     (in the image, the line graph currently "lies" in front of the bar graph. If I choose to have the bar graph at the forefront, I would set the line graph behind the bar graph using the "Send to back" option displayed)

    Using these options you can set the "layer depth" of each visual within a page: those at the forefront will "cover" the ones behind and viceversa. This is not dynamic in nature, however: once set and saved, that is how it will be "layered".