One graph and multiple-variables

[Anonymous]

Hi folks,

I have a question about the flexibility of PowerBI.
I need to show one only combo graph (lines and bar charts). The idea with one segment or filter I can manipulate it (X = date and Y are values). 

Two variables, add a second Y axis it's possible, so I can set Y left one scale and Y right another one. Same time date on X axis.

But, if I need 6 multi-levels, each one are selector (levels of products by categories), all of them are indipendent, each one have their values, but all of them share same time period, could I plot 6 or more trends on the same graph?

Example:

sorry for my draw, it's horrible, yes I know

I select 1, and I plot blue line

after I select 2 and I plot red line

after I select 2 again, I choose another item, and I plot a bar (for example)

after I select 3, and black line appears on main graph.

On X axis always are a time period (well I have a date selector).  Is it possible by PowerBI? Did I need a special formula for it?

thank you for your help. 

[Stachu]

I think you could achieve this behaviour with bookmarks and multiple overlapping graphs, where clicking on a slicer shows relevant graph on the top while hiding others. It would still look like single graph, but it would be in fact multiple graphs. Still whith what you're trying to achieve it seems to be really lot of work, and very difficult to maintain in case of changes

I guess you could also include a flag in the measures to only show them if a specific item is selected and use bookmarks only for changing type of a visual from line to bars

So I'd say it's technically possible, but personally I'd avoid implementing it 

[Anonymous]

Thank you @Stachu , yes you are right, after two weeks I achieved to do only one graph (exactly multichart by vidx), and one slicer with 6 differents categories, but only one category at once did work. So I think about a bookmark, and maybe could be a temporary solution.

I read developer documentation and it's possible to do a custom plot by node.js, someone did to achieve it and share your experience about a complete custom dashboard and the time to effort it? 

Thank you!