Show/Hide Visual based on Slicer Selection in Power BI | Realtime scenarios| Learnatcloudanalytics

#learnatcloudanalytics
#powerbi
Show/Hide Visual based on Slicer Selection in Power BI | Realtime scenarios| Learnatcloudanalytics
Note: Do not hit on this URL 👉bit.ly/3ArlahQ
This video helps us to show/hide visual based on slicer selection on a specific column. Here i ve used a simple boolean DAX function, ISFILTERED to return true value when there are any filters applied on a specified column. By default this function returns either a true or false value and so i have converted the output to Integer. The measure is then applied as a visual filter to get this requirement.
-------------------------------------------------------------------------------------------------------------------------------------
Learn How to become a Power BI developer 👉
This Complete Power BI Tutorial takes you Step-by-Step as you use Power BI Desktop to create a beautiful Power BI Dashboard. 👉
✅ Subscribe to always get my latest videos: / @learnatcloudanalytics
▶️Topics Covered in this playlist includes◀️
1. Get Data (Query Editor)
2. Relationships
3. DAX
4. Visuals
5. PowerBI.com
6. How to become a Power BI developer
7. Roles and responsibilities of a Power BI developer
8. DAX functions
9. Data modeling
10. Reporting tips & tricks
11. Power BI features
----------------------------------------------------------------------------------------------------------------------------------------
For videos on DAX functions 👉
1. What is DAX: • What is DAX and its im...
2. SUM vs SUMX : • SUM vs SUMX in Power B...
3. SAMEPERIODLASTYEAR : • How to create SAMEPERI...
4. PARALLELPERIOD: • How to create PARALLEL...
5. Calculate DAYS In YTD: • Calculate days in YTD ...
6. YTD | QTD | MTD : • How to Calculate YTD, ...
7. TOPN : • TOPN DAX in Power BI |...
8. RANKX : • RANKX in Power BI | Ho...
⚡Happy learning - Power On!⚡
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► / sailaja-chintala
Twitter ► @chintalasailaja
Gmail ► [e-mail]

[@TallHobbit17]

Thank you so much! I was having a really hard time finding a solution to this and this is such a nice and simple one.

[@archanasahoo3738]

My requirement is on selection of one porticular value inside slicer A, slicer B should hide, for rest of the value selection slicer B should come .

[@narendrareddy8420]

This does not work when we have a select ALL option in the slicer, is there any changes that needs to be done to the existing measure, can you help for this case?

[@phanibabu7408]

This video has been very helpful to me. Thank you for sharing it. The video shows how to apply this to pivot tables. Can we apply it to graphs as well? Actually, I'm looking for a video like this to help me change the names of the fields in the graph.

[@learnatcloudanalytics]

@Phani Babu: This works for all visuals except for card visual. And regarding your other query, to rename the fields in the graph, this can be achieved in the data transformation layer i.e., using Power Query editor, we would be able to change the names as desired. To do this, from home ribbon, select Transform data -> within P.Query editor, select the column whose values need to be modified -> select replace values and update as required. I hope this clarifies your query.

[@Face123ish]

Its not show/hide visual. Its showing no data, but the visual is there

[@learnatcloudanalytics]

Its actually hiding the visual based on the filter we have applied.

[@sakshinaik05]

Mam how to calculate rolling 12 months avg sales this has been asked in an interview

[@learnatcloudanalytics]

Will do a video and post tomorrow

[@ambarraut4642]

It worked, that is amazing! but I don't know why, after adding "select all" in slicer it wont show all the bar, but instead will keep it blank, please help😊

[@BigDataSport]

doesnt work on pivot tables if the only have measures, any idea or workaround

[@user-tl8ez6hg1z]

Hi, had tried its working with all other visuals , but facing a issue with the pie chart , where couldn't give a condition in Filter after selecting the measure.

[@nageswararaojayanti4449]

Thank you for the video. It's very helpful.

[@learnatcloudanalytics]

Thanks @Nageswararao 🙏

[@PS65501]

How to do this for a table or matrix ? If you hide data still the headers are visible

[@ksr5238]

pls do a video on types of refreshes in power bi (incremental refresh)

[@learnatcloudanalytics]

Sure, will do

[@ksr5238]

@@learnatcloudanalytics thanks

[@AyushSharma-dd4ul]

But what about the x and y axes titles that are coming up, can we hide them too?

[@learnatcloudanalytics]

Hi Ayush, Yes we can hide them by doing some formatting on the X and y axes titles. Just disable the titles for x,y axes along with the visual title. And it should work now

[@sundeepyanamala]

Thanks for your video. what we are showing selected values working fine on visuals and I have small doubt how to we implement selected values on card.

[@learnatcloudanalytics]

@Sundeep: Could you please explain your requirement

[@user-tl8ez6hg1z]

Hi, tried this works on all the visuals but couldn't find working on the PIE chart visual where selecting the Measure in the filter section , cannot find the option to give condition.

[@learnatcloudanalytics]

Hi, could you share your use case. As this video has a solution on dimension based slicer and it works perfectly fine.

[@umasankar3369]

Thank you ❤️

[@jyothish8807]

This approach doesn't work when we enable "select All" option in the slicers and select all the values. Is there any workaround for this scenario? Thank you !

[@learnatcloudanalytics]

Hi Jyotish, This solution does work even when we have select all enabled for the slicer. I have tested this again. Kindly check and confirm

[@taizoondean689]

Thank you for posting such helpful videos 🙏

[@learnatcloudanalytics]

Thanks @Taizoon

[@reddssful]

Thanks for the video. The problem is that tooltips won't work in all visuals. It will work only for that that is on top. Any ideas?

[@learnatcloudanalytics]

Hi Reddssful, could you please provide more details as I have not spoken on tooltips here.

[@reddssful]

I only mentioned that this approach doesn’t allow using tooltips, which is something that I need in this scenario

[@learnatcloudanalytics]

@@reddssful could you pls explain in detail. How do you want the tooltips to work.

[@anjaneyuluchilamakuru1176]

How can we hide the border of the visual if nothing is selected from the slicer?

[@learnatcloudanalytics]

@Anjaneyulu: We would need to turn off the visual border as it is related to formatting and not to the data.

[@yasinnadaf2974]

How to make a dax Colum that include Statement that contain 1. " = Then

[@learnatcloudanalytics]

Can you provide details scenario with sample data and expected output

[@yasinnadaf2974]

@@learnatcloudanalytics yeah sure your mail pls

[@inderr7bajaj]

I appreciate the effort but this is not hiding the visual. This is making the values 0. We cannot hide visuals in Power BI.

[@djenral6153]

Good Idea... Thanks for sharing

[@learnatcloudanalytics]

Most welcome 😊

[@Nit1601]

Will it work for a card visual ?

[@learnatcloudanalytics]

@Nitin: Except for card visual this works for every other visual.

[@guessthecode27]

@@learnatcloudanalytics so what DAX can be used for cards visual ?

[@karanmalkhede6689]

Make more videos

[@learnatcloudanalytics]

Thanks @Karan for supporting our channel. Sure, will do more videos