Format Data Labels for specific range

[Anonymous]

Hello All,

I started Power BI few weeks before and looking for few suggstions.

Objective - To represent month on month performnce of a team which handle help desk issues. Success rate is calculated based on the number of issues resolved from total issuues received. The team has a mimnum target as 98% to achieve.

• Number of issues/Month
• Un-Resolved issues
• Successrate
• Threshold

Am using line and Stacked column chart to represent it (refer below image), however it looks little messy. Anybody could advice to get it alligned properly?

1. Anyway to hide data lables for the threshold?

2. Anyway I could complare Jan17 and Jan18 data adjacent(Clustered)?

Performance Review & Data

Apprecaite your help.

Thank you 

Bharath

[v-piga-msft]

Hi @Anonymous,

---

 1. Anyway to hide data lables for the threshold?

2. Anyway I could complare Jan17 and Jan18 data adjacent(Clustered)?

---

1. By my tests, there is no options to hide the single data label directly on the line and Stacked column chart in Power BI Desktop currently.

You could vote this similar idea here and add comments there to improve Power BI and make this feature coming sooner.

For the workaround, you could try to use Tooltip which is a New feature in March Power BI Desktop. The output is below.

You also could have a reference of my test pbix file.

2. You could create a Month Slicer to filter the data of January, then you could have a comparison.

 

Best Regards,

Cherry

[Anonymous]

@v-piga-msft

Thank you for your promt response. I have voted for the idea 🙂