Forum Discussion
Make visual blank/display instructions until other visual selected to filter
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
Pmorg73 I am also having the same issue. Did you find solution for that. Please let me know how to overcome this issue.
Post Patronno not yet, sems to only work with measures and not straight tabular data. Will start a specific thread for it I think
Pmorg73 Thank you for making it clear. If possible, could you please provide the exact Measure to get that functionality. Thank you in advance.
Pmorg73 Thank you for making it clear. If possible, could you please provide the exact Measure to get that functionality. Thank you in advance.
- Pmorg73
Hi. I find that if I used a data entry in the code below it does not allow it, they do not list in the selectable items when typing where it says Calculate("07_workflow......). I then made a measure to sum up my estimated time. Once I did that it shows up in the list of acceptable to select when typing in "'07_workflow......". Hope that explains?
The isfiltered(item) is the item I have in my slicer. So when the slicer of "Job summary" is not clicked it returns a no calculation. Once selected it calculates the measure.
Time Est = if(isfiltered('02_Job List'[[Job]] Job Summary]),CALCULATE('07_Workflow Time Report'[Time Est Sum]))I then made the following measure and apply it to a card. I put that behind my table. Table is blank and this text shows until someone selects something
Show Text = if(isfiltered('02_Job List'[[Job]] Job Summary]),"","Select Job")This window is not allowing me to upload an image of my report 😞
I think a solution might be to create a measure that selects the text values I am trying to blank out. I will look in to that next
Pmorg73 Thank you for your response. This is somewhat similar to what I am looking for but still I am not able to get the result I wanted. let me explain my issue in detail,
- I have a concatenated column named "Column 4"
- I use this "Column 4" in a "Text Filter" (it is a custom slicer)
- Below the custom slicer there is a table which has columns, used to create "Column 4". Out of these columns, there is one column for the "URL"s
My requirement is "When I enter some thing in the custom slicer, that data should be filtered from the entire data. And when I clear the data in the custom slicer then a blank table should show up." For that I created a CARD using the following measure.
Make Transparent = IF(ISFILTERED(Table Name[Column 4] ), "#FFFFFF00", " ").By using this measure I can get the desired result. But the issue is when I filter something and if it has a URL, then I am not able to click on that URL because of a CARD on top of the TABLE .