How to create two chart

[Pbiuserr]

Hello,

I have two measures - Sales Amount and Sales amount LY

I would like to create a chart with category as axis and these measures

also a slicer with TOP 10 and full chart by Sales amount

I kind of know how to start but cannot manage only TOP10 or FULL chart options.

Could you please help me?

[davehus · Accepted solution]

Hi @Pbiuserr ,

See example attached. This uses a disconnected table and a selected value clause. If is less than 10 show top 10, if is less than 999 show all and filter added to the visual. 

Did I help you today? Please accept my solution and hit the Kudos button.