Forum Discussion

Pbiuserr's avatar
Pbiuserr
Post Prodigy
4 years ago
Solved

How to create two chart

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?

 

Need Help
  • davehus's avatar
    davehus
    4 years ago

    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.

1 Reply

  • davehus's avatar
    davehus
    Memorable Member
    4 years ago

    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.