Is it possible to combine simple and advanced model?

6.16K viewsadvance model; slice

I am new to use valQ visual in my Power BI report. I just followed the profit margin model video to create my first report, which is good. Now I want to see if I can slice this model by product brand. As soon as I introduce additional field under category, all the nodes become blank. It seems like each node needs to be linked to a specific account and brand. This is almost impossible to do if we have lots of brands which make me think maybe this is not the right tool for me (I’d like to do what if analysis). It also makes it less dynamic as the brand might change from time to time in certain region. Does any one know if I can achieve this by using this tool?

Also, is there any way to hide the variance section in each node? Sometimes we just have one aggregated data for pre-defined time period, so no need to show the variance or time period variance.

Thanks in advance,

Wenchi Wang

Answered question

Hi Wenchi Wang

It is not possible to combine both.

We can create an advanced model and add a node which can have dynamic children below it (this would be kind of dynamic).



Posted new comment

Thanks for your feedback. We currently use standard what if analysis from Power BI. One report, we have about 99 input fields which makes the report very slow in response due to intensive memory used to process all dax formula. Will your visual handle better with this many input parameters?

Hi Wang

Thanks for your response could you please connect to me at:

You are viewing 1 out of 2 answers, click here to view all answers.