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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kettsn
Frequent Visitor

linking two colums or more to 1 graph and slicer

Hi I have a few tables with English A-E data and Maths A-E data how do I make these two tables go on 1 visualization graph and 1 slicer sort A-E

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @kettsn ,

According your describtion,refer the below:

TableA;

vluwangmsft_0-1653875232970.png

 

TableB:

vluwangmsft_1-1653875244387.png

First ,create slicer table:

vluwangmsft_2-1653875345800.png

Then create another table base on tableA and table B:

TableC =
UNION (
    SELECTCOLUMNS (
        TableA,
        "Tpye", TableA[type],
        "Table", "TableA",
        "Value", TableA[value]
    ),
    SELECTCOLUMNS (
        TableB,
        "Tpye", TableB[type],
        "Table", "TableB",
        "Value", TableB[value]
    )
)

vluwangmsft_3-1653875655803.png

Relationship:

vluwangmsft_4-1653875736566.png

Final output:

vluwangmsft_5-1653875821395.png

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

Share some data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-luwang-msft
Community Support
Community Support

Hi @kettsn ,

According your describtion,refer the below:

TableA;

vluwangmsft_0-1653875232970.png

 

TableB:

vluwangmsft_1-1653875244387.png

First ,create slicer table:

vluwangmsft_2-1653875345800.png

Then create another table base on tableA and table B:

TableC =
UNION (
    SELECTCOLUMNS (
        TableA,
        "Tpye", TableA[type],
        "Table", "TableA",
        "Value", TableA[value]
    ),
    SELECTCOLUMNS (
        TableB,
        "Tpye", TableB[type],
        "Table", "TableB",
        "Value", TableB[value]
    )
)

vluwangmsft_3-1653875655803.png

Relationship:

vluwangmsft_4-1653875736566.png

Final output:

vluwangmsft_5-1653875821395.png

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

Hi I tried that solution but it still didnt use 1 slicer to slicer all my graphs. See image below for what I am trying to achieve. I dont want a slicer for each graph. I want to be able to select options base on A-E is this possible

 

BI Snip.png

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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