Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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...
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |