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:   I want to sort this chart by Date of Version (it should be 0.9.1 first, then 0.10....
Need Help
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost 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
      Icon for Most Valuable Professional rankMost 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.

       

      • mwegener's avatar
        mwegener
        Icon for Most Valuable Professional rankMost Valuable Professional
        6 years ago

        Hi pboron ,

         

        check this out.

        PBIX

        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.

    • v-diye-msft's avatar
      v-diye-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi pboron 

       

      Please add the measure below, and then sort the version by measure:

      Measure = 
VAR t =
    SUMMARIZE (
        ALLSELECTED ( 'Table' ),
        'Table'[Date],
        'Table'[Version],'Table'[Value],'Table'[Result]
    )
RETURN
    COUNTROWS (
        FILTER (
            t,
            ISONORAFTER (
                    'Table'[Date], SELECTEDVALUE ( 'Table'[Date] ), DESC,
                    'Table'[Version], SELECTEDVALUE ( 'Table'[Version] ), DESC
            )
        )
    )

       

      Pbix attached.