Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Power BI enthusiasts,
This is the YouTube Tutorial I followed to create a Power App.
https://www.youtube.com/watch?v=-dRDKbm-v6Y
The step where I'm stuck is the Row ID for my multi-category table.
Note: Also why do I have to use this workaround this Data Appended table I'm using is from Excel and write the changes back to excel.
Then I used these 2 tutorials to calculate the row ID:
I faced a few problems:
Problem 1: You can see the problem that the Row ID is not unique for the categories.
I want the expected row numbers to be like just a unique 1-3 digit number.
Problem 2: Also, the most important aspect of this app is to show the 'WRK CAGR Est.' beside the CAGR '21-25. But when I add this to the existing table it replicates the table entries into 2.
PLEASE TRY TO FIND A SOLUTION TO THIS PROBLEM!!
I'm sharing the .pbix file that has the OG report:
https://drive.google.com/file/d/1vWWg52y7WC7_CYgkatbj_5eaMx7soLZt/view?usp=sharing
P.S.: I will be very grateful if you are able to provide some solution/guide to this problem before Monday. I have to show this to my client.
Solved! Go to Solution.
Thank you for spending your time creating a solution. But, in this case, this is not useful for me, because there has to be a relationship between table 'wrk cagr' and table 'End Market Projection' for the 'Row ID' fields.
Anyways I was able to find a solution. I'm attaching the .pbix file for anyone who wants to see for themselves.
https://drive.google.com/file/d/1nRa7FE7uhnyf4zNHMjtj9g6tvhrtd4ti/view?usp=sharing
What did I do to solve this?
Note: For numbers 1 & 2 I followed the tutorials mentioned in my question above.
In this way I was able to have to be a relationship between table 'wrk cagr' and table 'End Market Projection' for the 'Row ID' fields.
Final Table Look:
Warm regards,
Priyanka Jha.
Hi @PriyankaJhaTheA ,
Where are you now, and are you still stuck in the above questions? Looking forward to your reply.
Best Regards,
Henry
Thank you for spending your time creating a solution. But, in this case, this is not useful for me, because there has to be a relationship between table 'wrk cagr' and table 'End Market Projection' for the 'Row ID' fields.
Anyways I was able to find a solution. I'm attaching the .pbix file for anyone who wants to see for themselves.
https://drive.google.com/file/d/1nRa7FE7uhnyf4zNHMjtj9g6tvhrtd4ti/view?usp=sharing
What did I do to solve this?
Note: For numbers 1 & 2 I followed the tutorials mentioned in my question above.
In this way I was able to have to be a relationship between table 'wrk cagr' and table 'End Market Projection' for the 'Row ID' fields.
Final Table Look:
Warm regards,
Priyanka Jha.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |