Is it possible to combine simple and advanced model?

6.83K viewsadvance model; slice
0

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
0

Hi when you say 99 Input fields are they 99 different measures or 99 items to be keyed, could you please elaborate, if you are interested in a demo please let me know so that I can connect to the ValQ sales team to experience and understand ValQ.

As ValQ is not just another visual but a product by itself alltogether

Posted new comment

we have 11 brands and each brand has 9 input values, such as price, quantity and promotion, etc.. And yes, each input value has it’s own measure. I am open to any suggestion to make it run faster and user friendly. If you can schedule a demo for us, that would be great!

0

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).

Thanks

Harish

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: harishbk@visualbi.com