Forum Discussion

pboron's avatar
pboron
Frequent Visitor
6 years ago

Sorting chart by not showed column without changing tooltip

I have a chart showing value for different versions for certain products. Here's simplified version:

Chart with slicer

 

Table

I want to sort this chart by Date of Version (it should be 0.9.1 first, then 0.10.1 and then 0.11.1) and I can't use option 'Sort by column' for Version, because sometimes there are different products, which have versions named the same and I'm getting error, that I can't 'Sort by column', because there are different values in Date for same value in Version. I tried adding Date to tooltip and then sorting by Date in chart, but sometimes there are a lot of values and I want tooltip to show only values (it was showing date for each value, so if I had 3 values it would change to 9 lines on the tooltip and if I had more, it wouldn't even show every value, cause it then takes 3 lines for every value and Power BI for some reason limits tooltip to 11 lines). Are there any different ways to sort chart by column, which is not used in it?

 

Pbix file to download if needed.

Need Help

6 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi pboron ,

     

    I generated a sortable version number in Power Query.

     

    You may download my PBIX file from here.
    Hope this helps.

     

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

    • pboron's avatar
      pboron
      Frequent Visitor
      6 years ago

      But that just sorts Version by name correctly (so that 0.10 is after 0.2, not before for example). I want to sort Version by date. There may be situations, where e.g. first there is version 0.0.1 made, then 0.1.1 and then 0.0.2 and I want to show it in this order, not 0.0.1, 0.0.2, 0.1.1

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        Hi pboron ,

        can you add some kind of build number (date) to your version number?

        So that it becomes unique and can be sorted according to it?

         

        Regards,

        Marcus

        Dortmund - Germany
        If I answered your question, please mark my post as solution, this will also help others.
        Please give Kudos for support.

         

  • pboron's avatar
    pboron
    Frequent Visitor
    6 years ago

    v-diye-msft - Measure don't show up in 'Sort by column' in my Power BI. But even if it would, I don't think it would work, cause it would be the same problem, that there are some values in Version, that have different values in your measure. I saw in pbix file you attached, that you added your measure to chart tooltip and then sorted chart by it, but I can't do that, cause it clutter tooltip too much.

     

    mwegener - I checked pbix file you attached, but I'd like to avoid adding date to Version if possible, cause it again clutter chart too much, espacially that sometimes there are more than one version in a day, so it would have to be more than just year, month, day.

     

    Isn't there a simple solution to just sort chart by column, that's not used in it, without changing anything?