Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Power BI community,
I would like to give the user the possibility to choose in which column the element from dimension table will appear in the matrix. That is why I created three slicers for each position of matrix table. If the user selects BMW from Slicer 1, I expect that this element will appear in the first column of the matrix. The same applies to Slicer 2 and Slicer 3. The user can select any and only one element from each slicer. So applying alphabetical order or any other predefined rule is not possible. I assume I need a UNION of all selected values that I can use as a column dimension in the matrix.
I tried to use calculation groups. I am able to define calculation items that take selected value from each slicer. That works fine, but the calculation item's name (that is shown as the header of column) is static. I also tried to use dynamic textboxes that I positioned over the column headers. However, they don't move with scrollbar on the matrix if we enlarge our example to more than only 3 column (e.g. 10).
Any ideas? Anything is appreaciated.
@Martin-PBI , To me it seems like you need 2-3 independent slicers and measures based on that. A measure need to be split future you need calculation groups
refer for approch
Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
In Calculation Groups, edited the table manually, check that can help
@Martin-PBI , To me it seems like you need 2-3 independent slicers and measures based on that. A measure need to be split future you need calculation groups
refer for approch
Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
In Calculation Groups, edited the table manually, check that can help
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |