Forum Discussion

utsavlexmark's avatar
utsavlexmark
Helper III
5 years ago

Sort the slicer based on Unique Visitors

Hello,

I am using a slicer that is containing different "tracking codes" and these tracking codes are used in URLs in external advertisements. There is a table in the dashboard that is showing which "tracking codes" proveded how many traffic and sales to our websites.

Now the "tracking codes" in slicer showing alphabetically. I want them to sort them based on unique visitors received from those tracking codes.

Any Suggestions?

Regards

Utsav

3 Replies

    • utsavlexmark's avatar
      utsavlexmark
      Helper III

      No,

      Format is like

      Tracking Code                  URL           Visits                 Unique Visitors              Pagesviews

      a1                                      XXX            20                         15                                      25

      b1                                     YYY             500                        450                                1000

       

      and so on...

      Now this page has a Slicer as "Tracking Code" and the codes are showing alphabetically over there; like "a1" at first and then "b1". Now I want to sort the "tracking code" in such a way so that in filter "b1" will show first as it has higher unique visitors.

      Regards

      Utsav

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi utsavlexmark ,

     

    Based on my research, now the sort function for slicer could only support a column, so I am afraid you could not sort your slicer dynamically, I suggest submit an idea in ideas forum:

    https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

    Best Regards,

    Stephen Tao

     

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