Sort the slicer values based on calculated column or measure

[smilika]

It doesn't give an option in the sorting. The slicer has to be sorted by calculated column.  Is there any ways? 

The connection I am using is Live Connection. Is there any way to sort the slicer values based on the measure. Can you give any suggestions please.

[Anonymous]

Hi @smilika ,

Based on the information you provided, I understand that you are unable to sort slicer values based on calculated column in Live Connection.

Notice that Power BI does not support direct sorting by metrics in slices. Slices can only be sorted by column.

I recommend you read this link here:

Solved: Sort Columns using Live Connection - Microsoft Fabric Community

If sorting by calculated columns is not possible due to real-time connectivity limitations, you need to consider sorting the data in the source system or using a different connectivity method (e.g. import mode) for more flexible modeling.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

^{Best Regards,}

^{Yifan Wang}

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