Filter by Comma-Separated Values with AND Slicer Logic |DAX TREATAS

Описание: My website
👉https://dancesingwithdata.com

Tableau Desktop Specialist Certification Course
👉https://learnwithritesh.graphy.com/co...

--------------------------------------------------------------------------------------------------------------------------
Learn how to build a dynamic Power BI report using comma-separated sub-categories and slicer logic! In this video, I walk you through a real-world dataset and show how to:
✅ Split comma-separated values into rows
✅ Create a slicer from a distinct sub-category table
✅ Use DAX and TREATAS to simulate AND logic
✅ Filter visuals based on multiple slicer selections
Whether you're a Power BI beginner or looking to level up your DAX skills, this tutorial will help you build smarter, more interactive dashboards.

---------------------------------------------------------------------------------------------------------------------------
🔗 Copy the dataset below and use as a CSV file:

Order ID | Product Name | Category | Sub-Category | Sales | Profit
1001 | Office Chair | Furniture | Chairs, Binders | 320.00 | 45.00
1002 | Whiteboard | Office | Art, Binders | 150.00 | 22.50
1003 | Desk Organizer | Furniture | Binders, Appliance, Art | 275.00 | 35.25
1004 | Stapler | Office | Binders, Appliance | 40.00 | 6.80
1005 | Sketch Pad | Art Supplies | Art | 60.00 | 8.00
1006 | Coffee Machine | Appliances | Appliance | 210.00 | 31.00
1007 | Pen Set | Office | Art, Binders | 35.00 | 5.50
1008 | Filing Cabinet | Furniture | Binders | 425.00 | 64.00
1009 | Drawing Tablet | Electronics | Art, Appliance | 475.00 | 70.25
1010 | Label Printer | Office | Binders, Art | 190.00 | 28.50

------------------------------------------------------------------------------------------------------------------------

Power BI
Power BI slicer
Power BI AND slicer logic
Power BI TREATAS
Power BI DAX tutorial
Comma separated values Power BI
Power BI slicer multiple values
Power BI dashboard
Power BI beginner tutorial
Power BI advanced filtering
----------------------------------------------------------------------------------------------------------------------