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 All,
I have these 2 tables in my PBI model
Table 1 | Table 2 | ||||
book | topic 1 | topic 2 | topic 3 | topic | |
book 1 | aaa 1 | bbb 1 | topic 1 | ||
book 2 | aaa 2 | ccc 2 | topic 2 | ||
book 3 | bbb 3 | ccc 3 | topic 3 | ||
book 4 | aaa 4 | bbb 4 | |||
book 5 | aaa 5 | ccc 5 |
Is it posisible to use the column topic of Table 2 as a filter and depending on its selection, a correspoding columns (topic 1, topic 2 or topic 3) would be displayed in a table like this?
That is, if I selected topic 3 in the filter, the visual would look like this?
Thank you in advance.
Solved! Go to Solution.
@nemo ,
First you need to unpivot Table 1,
After that you can create a matrix and you can slice it as you requested...
@nemo ,
First you need to unpivot Table 1,
After that you can create a matrix and you can slice it as you requested...
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |