Custom Sort Matrix - Custom Sort Order and Amount
Hi All, I am trying to sort a matrix where I have 3 "levels" in the row hiearchy. The first 2 levels, I have custom sort order tables built but for the 3rd click down, I want this sorted by amount in descending order. I have one data element in Columns and I have a few filters. Does anyone know if what I am asking is possible? I have created measures and calculated columns but Power BI will not let you sort by either of these and based on the filters, the amounts will change.
Custom sort two slicers from same table
Hi! Really hope someone can help! I have two slicers that corresponds to two different columns in the same table. I want to do custom sorting on both slicers, however i cannot seem to make this work. The table looks something like this: Key Column1 Column2 123 2 5 124 2 10 125 2 Free 126 5 5 127 5 10 128 5 Free 129 12 5 130 12 10 131 12 Free 132 Free 5 133 Free 10 134 Free Free I have tried creating a new table with the distinct values for column1 and the sort order, and then used the function "sort by column", which works for column1. However, I cannot seem to do this for the second column as well - in this case it tells me that the table is already sorted. Can anyone help?