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 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.
Post PatronI 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
It does yes. Both measures are needed as it is two items on the report. I did select "bringto front" on the table but I dont think it matters.
The "Select job" measure has a value when nothing is selected and is then blank when something is then selected. The other measure is the opposite, so they swap over, showing values as soon as something is selected for the table. Note I did a measure for all items within the table that I used.
I will upload my file for you shortly
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?
Thanks for that
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
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] -24What 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. 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
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.
Pmorg73 Okay, Thank you for your support till this point.