Solved: How to create two chart

Pbiuserr · ‎08-23-2022

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 · ‎08-23-2022

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.

View solution in original post

davehus · ‎08-23-2022

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.