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
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.

     

    • mwegener's avatar
      mwegener
      Most 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
    Community 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.