Forum Discussion

mukhan311's avatar
mukhan311
Frequent Visitor
2 years ago

Creating a category for waterfall using measures in Live connection

hi all,

 

I am trying to build a waterfall where I have different measures for sales amount, orders amount and opportunities amount. 

the biggest challenge I am facing is to create combined category for each of these measures in live connection mode. If you have a solution on how to create categories usinng measures then it will be really helpful. 

Thank you.

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi mukhan311 ,

    Because you are in live connection mode, you may not be able to directly create a new calculation table that merges measurements into categories. However, if you connect in real time to a model where you can modify the underlying data model, such as SQL Server Analysis Services, Azure Analysis Services, or Power BI datasets, you can create a calculation table in it. This table should have two columns: one for Categories and one for Amounts. You can then populate the table with rows representing different metrics.

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.