Forum Discussion
Impactful IndividualBar chart with dots and dashes
i need to show four KPIs or metrics on bar chart with different representation in Power BI as shown below , PBIX file is available as per below
https://drive.google.com/file/d/1ujieETFSGOfspdULAEScwqvlM7jVrRev/view?usp=drive_link
Dark blue color represent Revenue
Light blue color represent Operating Cost
Horizontal Dash (Orange color) represent Customer Growth %
Yellow circle or dot represents Profit Margin %
Years are on X axis
You can use a Line and stacked column chart for this. Example attached.
- Place measures in Column y-axis or Line y-axis field wells as required.
- For the line series, disable Lines and enable Markers.
- Set Marker shape and colour.
powerbiexpert22
Hi,
Steps to be taken:
1-In format visual pane, add Revenue & Operating Cost in Y axis.|
2- Add customer growth and profit margin in Line y-axis.3-Format customer growth in line shape (-) and make width 20.
4-Format profit margin in circle shape(.) and make width 6.
If this helps, ā Mark as Kudos | Mark as Solution| Help Others
https://github.com/Murtaza-007-007/Murtaza_PBI/blob/main/Formatting%20Lines%20and%20Visulas.pbix
4 Replies
- OwenAuger
Super User
You can use a Line and stacked column chart for this. Example attached.
- Place measures in Column y-axis or Line y-axis field wells as required.
- For the line series, disable Lines and enable Markers.
- Set Marker shape and colour.
Murtaza_Ghafoorpowerbiexpert22
Hi,
Steps to be taken:
1-In format visual pane, add Revenue & Operating Cost in Y axis.|
2- Add customer growth and profit margin in Line y-axis.3-Format customer growth in line shape (-) and make width 20.
4-Format profit margin in circle shape(.) and make width 6.
If this helps, ā Mark as Kudos | Mark as Solution| Help Others
https://github.com/Murtaza-007-007/Murtaza_PBI/blob/main/Formatting%20Lines%20and%20Visulas.pbix
v-sgandrathiCommunity Support
Hi powerbiexpert22,
Thank you Murtaza_Ghafoor and OwenAuger for your response to the query.
Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help.Thank you.
- v-sgandrathi
Hi powerbiexpert22,
Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help.
Thank you.