Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have been attempting to solve this for a couple of days now, unfortunately I am a complete noob at power BI and I feel like I still don’t know where to start, and if this is even possible. Any help is therefore very much appreciated.
To illustrate my problem I have created a toy problem, which is the following:
Table 1: Total
Date | Revenue |
Jan 2018 | 1200 |
Feb 2018 | 1500 |
Mar 2018 | 1500 |
Table 2: Product
Date | Product | Revenue |
Jan 2018 | 0 | 500 |
Jan 2018 | 1 | 700 |
Feb 2018 | 0 | 700 |
Feb 2018 | 1 | 800 |
Mar 2018 | 0 | 800 |
Mar 2018 | 1 | 700 |
Table 3: Manager
Date | Manager | Revenue |
Jan 2018 | a | 300 |
Jan 2018 | b | 700 |
Jan 2018 | c | 200 |
Feb 2018 | a | 350 |
Feb 2018 | b | 650 |
Feb 2018 | c | 500 |
Mar 2018 | a | 400 |
Mar 2018 | b | 600 |
Mar 2018 | c | 500 |
My task is to create a meaningful dashboard with this data. And one of the main goals is to be able to use those categorical variables (i.e. manager and product) as filters.
So for example, I'd like to create something like this:
And when I click on one of the categories inside of the bottom two bar graphs, foe example on manager 'c', I' d like to see the top graph (the line graph) adjust as well. Is this possible? Or is there a better way to deal with this kind of data?
(P.s. This is a toy problem, the actual dataset has 7 categorical variables, which all have a lot more categories (500+) than shown in this example).
Creating a dimension table date which including a column month(e.g. Jan, Feb...) without duplicated value. linking this table to all tables' month column to create the relationship.
Proud to be a Super User!
Hi @TomOerlemans,
If you want to have the interaction between the graphs/tables, you should create the relationships between the tables.
However, for your scenario, it seems that we should create the relationship with the key Revenue. However, we cannot create the relationship with the Revenue. We only could create the relationship with Date, but that is not your requirement.
You may should have a good look at create relationship.
Best Regards,
Cherry
Alternative approaches in dealing with this kind of problem are appreciated as well..
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
109 | |
106 | |
90 | |
61 |
User | Count |
---|---|
165 | |
136 | |
134 | |
97 | |
86 |