Forum Discussion

dthompsonKairos's avatar
dthompsonKairos
Icon for Helper II rankHelper II
1 year ago
Solved

Horizontal 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.  ...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    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's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
1 year ago

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.