Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Visualizing a dynamic summarized table?

Hi all, I have a question regarding the visualizing of data from a dynamic summarized table.   The situation: We are doing Monte Carlo Analyses on risks. This analysis simulates every risk 10.000 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous,

    AFAIK, current power bi does not support to create dynamic calculate column/table based on filter/slicer.

    Filter/slicer operated on a virtual table generated from data model tables(calculated column/table also stored on this level), you can't use the child level interaction to affect the parent which generates them.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous,

AFAIK, current power bi does not support to create dynamic calculate column/table based on filter/slicer.

Filter/slicer operated on a virtual table generated from data model tables(calculated column/table also stored on this level), you can't use the child level interaction to affect the parent which generates them.

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Thank you for your reply.

As an alternative I moved the entire Monte Carlo analysis to the Python visual in Power BI, instead of extracting the results from SQL Server. This prevents the Python visual from reaching the 250.000 row limit, however it does impact the tenant performance.