Make different matrices dynamic

Data Visualizations
1

Hi everyone!
I have posted this question but didn’t get any answer, I would really appreciate your help. Here’s the issue :
To present my accounts in the order as you see in the file below, I had to import a data table that contains my accounts I want to display (PLMOD). I wanted also to display the details accounts to explain the main accounts that I have in the first matrix (the details account represent the elements that have the most impact on the main accounts). I created the measures for the elements that do not exist in my fact table (operational income…) And then used the switch function to display my data in the matrix as you can see.
The Problem is that my two matrices don’t interact, they are not dynamic. To solve that problem I created a relationship between PLMOD and Facttable. But when I do that, the elements with no Account Code disappear from my matrix. Is there anything I can do to make these matrices dynamic and interactive.
Thank you so much for your help.

Matrices relationship issue-1.pbix (137.8 KB)

2

Hi @Chaouiya, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

  • Use the forum search to discover if your query has been asked before by another member.

  • When posting a topic with formula make sure that it is correctly formatted to preformated text </>.

  • Use the proper category that best describes your topic

  • Provide as much context to a question as possible.

  • Include demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

I also suggest that you check the forum guideline https://forum.enterprisedna.co/t/how-to-use-the-enterprise-dna-support-forum/3951. Not adhering to it may sometimes cause delay in getting an answer.

3

Hello @Chaouiya,

Checking the model behind you file I thought I could try to re-do it following the Best Practices by:

  • build a new dimension table Accounts

  • Eliminate the unnecessary columns from fact tables

  • build only two measures (Actual and Actual LY)

The result can be seen below in the GIF file attached.

Matrices relationship issue- remodeled
Matrices relationship issue- remodeled1918×853 3.56 MB

Please let me know should you need the actual PBIX file.

If you liked my solution please give it a thumbs up :+1:.

If I did answer your question please mark my post as a solution :white_check_mark:.

Thank you !

Cristian

4

Relationship field need to have some unique field. In the absence of unique fields, system will not understand the data link and will provide incorrect data.