Today, we do a deep dive into a question about how to dynamically subset table visuals in Power BI based on slicer values. We’ll tap on a bunch of interesting elements including disconnected tables, slicer harvesting, slicer visualization tricks, virtual tables and conditional formatting.

Brian

***** Video Details *****
00:00 Introduction
01:18 The data model
01:46 Slicing data
03:31 Disconnected table
05:25 Single value slider
06:12 Harvest measure
09:37 Virtual table
11:29 Setting range measure
14:45 Conditional formatting

***** Related Links *****
Original Enterprise DNA Forum Question – https://forum.enterprisedna.co/t/filtered-table-in-a-visual/16210
Three Types Of Tables In Power BI And Why The Distinctions Matter – https://youtu.be/an25Huyjo3Q

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial