Measure not using the join or sort by column

[jak8282]

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

[Idrissshatila · Accepted solution]

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

[jak8282 · Accepted solution]

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

[jak8282]

Hi @Idrissshatila ,

Thanks for reply.  That still has not fixed it. 

Thanks

Chris

[Idrissshatila · Accepted solution]

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