Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Good day.
Simple data of 2 tables as below, and I want to display them in bars side by side.
I added a slicer using the month. One of the bars (data of percentage) is automatically accumulated (exceeding 100%), when the two percentage columns are of the same setting. It seems the problem lies in the Month in use but I can't figure it out.
Any help, please? Thank you.
.pbix is here: https://gofile.io/d/3XWybp
Solved! Go to Solution.
See attached pbix, you just needed to remove the old both side relationship and activate the new relationship.
Please let me know if this solves.
Hello @JohnnyK
Create at two more tables, using dax you can create automatic and dynamic tables--
Table1 - Get the unique Month from both tables, so this table will have just one column having unique months from both the tables.
Table2 - Get the unique Names from both the tables, so this table will have just one column having unique Names.
Now create relationship Table1 to your both orginal tables based on Months (one to many)
Create relationship Table2 to your both orginal tables based on Names (one to many)
Now in slicer, x asix bring Values/dimentions from these two new tables.
Please let me know if above is making sense, I could not access your file.
@mhossain, thank you for your help and details in steps. I've followed them, but the result's still the same .
Can you please have a look at the .pbix file? Thank you.
Unable to open the pbix, showing error, please re-upload and share
@mhossainthank you for the follow-up. please find the file, https://gofile.io/d/3XWybp
See attached pbix, you just needed to remove the old both side relationship and activate the new relationship.
Please let me know if this solves.
@mhossainthanks again for your patience and help! it works! in the bar chart it needs the Names from the new table (not the old table).
wish you a good day!
Right, both the dimensions will come from the new tables, Glad it worked, have a great time.
Hi,
Write a measure to take the average of Bonus % and Sold %.
@Ashish_Mathur, thank you. could you please advise the use of the measure (average of Bonus % and Sold %)?
Hi,
I believe your question has been answered.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
64 | |
52 | |
47 |
User | Count |
---|---|
216 | |
89 | |
76 | |
67 | |
60 |