Forum Discussion
Helper IIHorizontal Bar Chart with Lead Name and Score.
I thought this would be a peice of cake but it is turning out to be a pound yer head on the desk thing.
I just need a horizontal bar chart with a name on the X axis and the score on the Y axis.
PBi is summing the score. In this case the max score anyone can have is six but somehow PBi is coming up with scores up to 35. There is no option for "Don't Summerize".
I'm just going to go home now before I break something.
Thankyou, srlabhe, for your response.
Hi dthompsonKairos,We appreciate your query on the Microsoft Fabric Community Forum.
Based on my understanding, the bar chart is showing a sum because bar and column visuals must aggregate numeric fields. Since your leads have multiple rows, Power BI is showing the Sum of ProgressScore, which can go above your maximum of 6. The solution is to give the visual one value per lead by creating a measure that uses the maximum score for each lead.
Please find attached a screenshot and a sample PBIX file that may assist in resolving the issue:
We hope this information helps. If you have any further queries, please feel free to contact the Microsoft Fabric Community.
Thank you.
5 Replies
srlabheSuper User
Its actually summing all values in Progressscore as X-axis takes only measures.
v-pnaroju-msftCommunity Support
Thankyou, srlabhe, for your response.
Hi dthompsonKairos,We appreciate your query on the Microsoft Fabric Community Forum.
Based on my understanding, the bar chart is showing a sum because bar and column visuals must aggregate numeric fields. Since your leads have multiple rows, Power BI is showing the Sum of ProgressScore, which can go above your maximum of 6. The solution is to give the visual one value per lead by creating a measure that uses the maximum score for each lead.
Please find attached a screenshot and a sample PBIX file that may assist in resolving the issue:
We hope this information helps. If you have any further queries, please feel free to contact the Microsoft Fabric Community.
Thank you.
- v-pnaroju-msft
Hi dthompsonKairos,
We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.
Thank you. - v-pnaroju-msft
Hi dthompsonKairos,
We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.
Thank you. - v-pnaroju-msft
Hi dthompsonKairos,
We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.
Thank you.