cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
THENNA_41
Frequent Visitor

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 II
Super User II

wdx223_Daniel_0-1626939447582.png

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors