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.
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
No, this requires separate helper tables. No way around that.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |