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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

combine value and separate value to show visual

i have 5 columns each values are unique vlaues . i have one column DOM Filter .  DOM filter have combine value and also seperate value . i have attached sample date for reference 

Code    Value 1   value 2  value 3    DOM 

101        5            10           7            A104

101        5            10           7            B104,S104,A104

101        5            10           7            Z104,R104

101        5            10           7            G104,A104

101        5            10           7            O104

101        5            10           7            R104

101        5            10           7            S104,Z104  

 

 

 I  have seperate sheet for DOM filter  

DOM Filter 

A104

B104

Z104

O104

G104

R104

S104

 

If i select  value A104 in  filter value should come from combine value and seperate value . like

 

               VALUE 1         VALUE 2     VALUE 3

A104        15                    30              21 

any idea ?  thanks in advance .

1 REPLY 1
wdx223_Daniel
Super User
Super User

wdx223_Daniel_0-1626939447582.png

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.