topic Re: Dynamic Matrix Table in Custom Visuals Development Discussion

Dynamic Matrix Table

Anonymous — Fri, 20 Aug 2021 22:05:21 GMT

Hello everyone

I need to build a dynamic matrix table that all Rows, Columns and Measures change and build by the slicers. For examle if I consider 3 diffrent slicers like

Slicer1, Rows: Employees, Customers, Branches

Slicer2, Columns: Years, Condition

Slicer3, Measures: TotalSale, TotalProfit

The matrix build by the users selections to what they want to see and have in the matrix. I mean, the attributes that they need to have at that matrix change by the slicers.

I provide a conceptual picture of what I need to do.

Also, I dont want to Unpivot my tables or just dynamically change just my rows. I need everything build by user request.

Thanks a lot dudes

Re: Dynamic Matrix Table

lbendlin — Sun, 22 Aug 2021 16:24:13 GMT

Enable "Personalize visuals" and teach your users how to use that feature.

Re: Dynamic Matrix Table

Pnikzadbrandt — Mon, 23 Aug 2021 05:21:20 GMT

Thanks

You mean this is the only chance to do this? What if that I want to do it through another way? Not by the users

because we have this in Qlikview

Re: Dynamic Matrix Table

lbendlin — Mon, 23 Aug 2021 11:11:39 GMT

It's a fantastic feature. Your users will love it. Ours do.

Re: Dynamic Matrix Table

Pnikzadbrandt — Mon, 23 Aug 2021 14:57:03 GMT

No other thoughts on this? So, there is no other solution? Other apps like Qlik and Tableu have this

Re: Dynamic Matrix Table

lbendlin — Mon, 23 Aug 2021 14:58:18 GMT

At the risk of sounding curt - Have you considered using these other apps instead?

Re: Dynamic Matrix Table

Pnikzadbrandt — Mon, 23 Aug 2021 15:00:18 GMT

Actually we have this kind of report in Qlikview, and it works based on the filters not users, and we want to shift to PowerBI, without disturbing current method. I really hope to find a way to build this

Re: Dynamic Matrix Table

lbendlin — Mon, 23 Aug 2021 15:57:44 GMT

Trying to migrate reports from one system to another verbatim is a fallacy, often called "Fighting the API". There is a reason we have Qlik, Tableau, Power BI etc - because they are different. They have different USPs, different UX paradigms, different backend engines. Embrace the difference.