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
The issue with it is clearer, even to me, when I show it as a table.
This is how it looks as a table:
What I think I want/need is 2020 in one row and 2021 in another.
The bottom line is the question is how to I reorganize the data so that it is in two rows with 2020 in one row and 2021 in the other?
The reason I want them in two rows is because I want 2020 and 2021 to be all I have on the x axis. I want "Earnings" and "Potential Earnings" on the one vertical axis as a columns and "Percent of Potential Earned" on the other vertical as a line.
Data Model:
Each of these is from a different table. There are three one-way relationships between the tables. That’s …because each table’s primary key is a cluster of these 3 (ProviderID, AddressID, and IncentiveProgram)
Solved! Go to Solution.
Is this what you are trying to acheive?
Couple of things, Is there any reason that you can't append the you two tables together, they look identical.
Here is a link to a file that I put together to show you what I mean - mohassan99_sample.pbix.
I would also suggest you looking into some basic data modelling concepts in Power BI, I re read your first question about your data model and three relationships - relationships don't work how you think they do.
Thank you
I think I may have to append the tables in a query. Apparently a data relationship is not a join so, yeah, I wasn't sure what they were.
Thank you,
Mo
Hi @mohassan99
I would suggest introducing a calendar table and then summing your measures as totals, can you provide some dummy data and I can m show you how.
Thank you
Do you mean a date table? PowerBI says:
A date table is a table that meets the following requirements:
The data looks like:
Query/Data Source 1
Year | Provider | Value1 |
2020 | 1 | 10 |
2020 | 1 | 10 |
2020 | 2 | 20 |
2020 | 2 | 20 |
Query/Data Source 1
Year | Provider | Value1 |
2021 | 1 | 30 |
2021 | 1 | 30 |
2021 | 2 | 40 |
2021 | 2 | 40 |
Is this what you are trying to acheive?
Couple of things, Is there any reason that you can't append the you two tables together, they look identical.
Here is a link to a file that I put together to show you what I mean - mohassan99_sample.pbix.
I would also suggest you looking into some basic data modelling concepts in Power BI, I re read your first question about your data model and three relationships - relationships don't work how you think they do.
Thank you
I think I may have to append the tables in a query. Apparently a data relationship is not a join so, yeah, I wasn't sure what they were.
Thank you,
Mo
Spot on mate, best to append those in PQ before bringing into PBI
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 |
---|---|
114 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
150 | |
118 | |
111 | |
106 | |
95 |