create slicer for both column and rows

Hi Anonymous ,

I created a sample using two ways. One is creating a new table as a slicer. Another is unpivoting the columns. You could have a try.

• Create a new table manually

 

Measure = 
VAR a =
    SELECTEDVALUE ( 'Filter Table'[Column] )
RETURN
    SWITCH (
        TRUE (),
        a = "Basic", SUM ( 'Table'[Basic] ),
        a = "Affiliate", SUM ( 'Table'[Affiliate] ),
        a = "Blank", SUM ( 'Table'[Blank] ),
        a = "Student", SUM ( 'Table'[Student] ),
        a = "VIP", SUM ( 'Table'[VIP] ),
        a = "VVIP", SUM ( 'Table'[VVIP] )
    )

 

• Unpivot columns

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WOrTAMScxKTE38dACJR0lIwMgYWgCIoyBhAWcpxSrA1VbnA1RagkSBiswhKsyRVZalFmVnwdRa2gOJwzh2syAhIFSbCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [State = _t, Blank = _t, Basic = _t, Affiliate = _t, Student = _t, VIP = _t, VVIP = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"State", type text}, {"Blank", Int64.Type}, {"Basic", Int64.Type}, {"Affiliate", Int64.Type}, {"Student", Int64.Type}, {"VIP", Int64.Type}, {"VVIP", Int64.Type}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"State"}, "Attribute", "Value")
in
    #"Unpivoted Columns"

 

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.