Forum Discussion

121Balu's avatar
121Balu
Frequent Visitor
2 years ago
Solved

Split matrix column

Dear All,   Can anyone help on below Matrix table visual requirement, I have 2 values count and values and i ploted in matrix table with state and city however the count and values are plotted as b...
  • danextian's avatar
    2 years ago

    Hi 121Balu ,

     

    The native  matrix visual doesnt have an option to group the columns by a certain measure first then followed by another.  The closest you can get to with some advanced DAX is something as below.  Attached is a sample pbix you can play around with.  You may also submit this as an idea at https://ideas.fabric.microsoft.com/