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 Thank you for making it clear. If possible, could you please provide the exact Measure to get that functionality. Thank you in advance.
Post PatronHi. 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 .- Pmorg73
I just did this in my report. I made a measure for various card results that I want after the selection is made.
Summary = if(hasonevalue('02_Job List'[[Job]] Job Summary]),values('02_Job List'[[Job]] Job Summary]),"")So now in the image all the boxes on the left are blank until a selection is made.
Pmorg73 Does this query will bring the table forward and move card backwhen data is filtered?
Youu provided me two measures, which one should I use to fulfill my requirement?