Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hi ,
I have one problem kindly help me to sort this out:
I have one data set in which brands and respective their respective search values are there. And I have another dataset in which I have done unpivoting and have one column name as Attributes and other as Values. Based on these Attributes values are present and their respective brand is present.
Now, I need to implement a relation between these two datasets as if in 'Data2', Attributes = A then Values should be > 0 and based on this brands should pick in the table.
Attributes would be in Slicer (A,B,C and D as dropdown). In Table in Rows as "Brand" variable . But when I select "A" in Slicer then in table I should see only sub categories of A same with B, C and D.
Brand | SI | A | B | C | D |
B | 0.839881 | 0 | 1 | 0 | 0 |
Bb | 6.514407 | 0 | 2 | 0 | 0 |
Bbb | 0.03975 | 0 | 3 | 0 | 0 |
A | 1.0485 | 1 | 0 | 0 | 0 |
Aa | 0.449527 | 2 | 0 | 0 | 0 |
Aaa | 0.36436 | 3 | 0 | 0 | 0 |
C | 2.125201 | 0 | 0 | 1 | 0 |
Cc | 2.168612 | 0 | 0 | 2 | 0 |
Ccc | 2.037037 | 0 | 0 | 3 | 0 |
Dd | 8.476445 | 0 | 0 | 0 | 2 |
D | 2.224267 | 0 | 0 | 0 | 1 |
Ddddd | 0.034427 | 0 | 0 | 0 | 5 |
Dataset2 (unpivot)
Brand | SI | Attributes | Values |
B | 0.839881 | B | 1 |
Bb | 6.514407 | B | 2 |
Bbb | 0.03975 | B | 3 |
A | 1.0485 | A | 1 |
Aa | 0.449527 | A | 2 |
Aaa | 0.36436 | A | 3 |
C | 2.125201 | C | 1 |
Cc | 2.168612 | C | 2 |
Ccc | 2.037037 | C | 3 |
Dd | 8.476445 | D | 2 |
D | 2.224267 | D | 1 |
Ddddd | 0.034427 | D | 5 |
Suggest.
It is solved. Thanks for asking.
Hi @SK87,
Thanks for your reply! That’s great! Could you please share your solution and mark it by Accept as Solution to help others who may encounter similar problems find it more quickly? Thanks in advance!
Best Regards,
Community Support Team _ Caiyun
Hi @SK87 ,
Not very sure about your needs. If you still have problems on it, could you please make it more clear? Thanks in advance!
Best Regards,
Community Support Team _ Caiyun
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
12 | |
10 | |
10 | |
8 |
User | Count |
---|---|
16 | |
15 | |
15 | |
12 | |
10 |