Forum Discussion

jak8282's avatar
jak8282
Helper III
3 years ago
Solved

Measure not using the join or sort by column

Hi,

 

I have a Client type table which is joined to a Forecast table

 

On the client type table there is a sort by column  which puts the client type in order.

 

However the measure that uses the Forecast table doesnt seem to put the values using the 'sort by' and the numbers are a bit all over the place when placed in the visual.

 

How do I get around that?

 

Many Thanks

  • Hello jak8282 ,

     

    try clicking on the three dots on the top right of the visual and then sort the visual with the client type.

     

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

     

    Follow me on Linkedin

     

  • Ths issue was to do with a power query step which was causing the data to look incorrect.

3 Replies

  • Hello jak8282 ,

     

    try clicking on the three dots on the top right of the visual and then sort the visual with the client type.

     

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

     

    Follow me on Linkedin

     

  • Ths issue was to do with a power query step which was causing the data to look incorrect.