Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mateoc15
Advocate I
Advocate I

User filter on all but one value

I have a data set for A/B testing where I have a control and multiple variations, like the list below.  I want to create a column chart with the control on the left, and then whatever values the user wants to filter to come after that.  I want to always include the control value, and only allow users to include/exclude other values.  Any ideas?  Thanks!

 

Values

-----------

CONTROL

V1

V2

V3

3 REPLIES 3
lbendlin
Super User
Super User

No, this requires separate helper tables. No way around that.

lbendlin
Super User
Super User

That is a standard pattern of a table union.  Create two tables, one with Control, the other with V1,V2,V3.  Feed the second table to the slicer.  Use a union of both tables for the visual and the rest of your data model

 

Provide sample data if you want to see an implementation.

Thanks for the reply!  By table do you mean data source?  I'd really rather not do separate queries if that's the case.  Can a calculated column for control/non-control flag be leveraged?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.