Skip to main content

Power BI One Slicer to filter other slicers based on Items that has value only without BI Direction



Ref Video : 

https://www.youtube.com/watch?v=cyOquvfhzNM

https://www.youtube.com/watch?v=MeLaZFst02E


Step-1

    Create a measure like below.

Cascading=

   COALESCE(DISTINCTCOUNT('table'[ID]),0)

Step-2
    Put the created measure in this in this visual section of slicer pane as shown below


Step-3
    Now in the filter slicer only the relevant data related to the another selected slicer will only appear.


Comments

Popular posts from this blog

Herbal Plants

Herbal plants to grow in home Different types of keerai ----- http://www.indiandietrecipes.com/2016/03/pictures-of-various-types-of-greens-or.html Pirandai ----good for bone joins---- https://youtu.be/k2DGubyXLAE Valarai Keerai Benifits ----- https://youtu.be/33HIfLJKTqA Sesma seeds ---- https://easyayurveda.com/2011/02/24/sesame-and-sesame-oil-benefits-total-ayurveda-details/

Convex Lens Vs Concave Lens

What is a Lens A lens is a transparent object that transmits light across it, and its working principle depends on the   law of refraction (Snell’s law) . Applications: Concave Lens help with Far-Sight Convex Lens help with Near-Sight

What is Verbal and Non-Verbal communication

TYPES OF COMMUNICATIONS: