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.
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
Solved! Go to Solution.
Hi @kettsn ,
According your describtion,refer the below:
TableA;
TableB:
First ,create slicer table:
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]
)
)
Relationship:
Final output:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi,
Share some data and show the expected result.
Hi @kettsn ,
According your describtion,refer the below:
TableA;
TableB:
First ,create slicer table:
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]
)
)
Relationship:
Final output:
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
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 |
---|---|
109 | |
97 | |
80 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |