Add legend, hide Total and change sentinel words

[perezcotai]

Hi there, Is possible to add legend, hide the total and have the option to change sentinel words from chart?

your custom viz work great... thanks for you effort.

[nishantjainuk]

Hi @perezcotai

Could you please explain a bit more about your suggestions.

Legend: There isn't usual a legend in waterfall chart. The only information that you can display is what each of the sentiment colors mean i.e. great = positive, red = negative etc. There aren't any other colors available to show in the legent.

Hide totals: Can you be more specific what you mean by hiding totals?

Change sentiment words: Again, sentiment (i.e. Total, increase and decrease) these are not show in the chart at the moment. Is that what you mean by legend?

Please provide screenshots if possible of what you would like to see.

Again, thanks for your feedback and would appreciate if you could leave a feedback on the appsource

[perezcotai]

The idea that I have in mind with the legend. For example: If the measure has “Low value is good “. The decrease of the Metric A(Contributors)Green negative value The increase of the Metric A(Detractors) RED positive value

But if the measure now has “High value is good”. The increase of the Metric S(Detractors) Red positive value The decrease of the Metric S(Contributors) Green negative value

For the sentiment words have the opportunity to show Low value is good. Decrease show the word Contributor Increase show the word Detractor High value is good. Increase show the word Detractor Decrease show the word Contributor

Then for total get the option to show or not show it in the chart.

let me add the feedback in the appsource.

[nishantjainuk]

Got it. It's a good suggestion. Let me get this up and running. Would you be interested in testing this version before it is published by Microsoft for general availability.

Thanks Nishant

[perezcotai]

Absolutely I am glad to help test it as many time is need it.

[nishantjainuk]

@perezcotai

I hope you are doing well. I have updated the custom visual to include your suggestion. I have submitted this to Microsoft however it will take about 4 weeks for it to go live on appsource.

In the mean time, you can download the beta version of the visual from here

The new features available are:

1. Legend: The legend is now available. By default, it is switched off but you can switch it on from the properties pane. You can also change the "text" to be used for favourable and adverse sentiment
2. You can now remove the "Total" bar by switching off the "Show cumulative total" option in the "Define Pillar" section.

I would appreciate if you could test and provide your feedback on these features.

Nishant

[perezcotai]

Let me do the test.. :)

[perezcotai]

The two new features work perfect :). But "fit to width" for the chart alias FitToWidth stop to work and the decimals numbers from the format stop to work.

[nishantjainuk]

@perezcotai

I have updated the visual. Can you download it again from this link and test it. Appreciate your support with testing

Thanks Nishant

[perezcotai]

Sure

[perezcotai]

let test again I am getting almost the same issue for one of them. The "fit to width" is working back[in the Horizontal chart], the decimals numbers from the format are working partially.

[perezcotai]

Review all the FitToWidth for the vertical Chart Option is also not working anymore

[perezcotai]

let me know if you need help for test

[nishantjainuk]

Thanks

The latest version is available here

https://github.com/nishantjainuk/SimpleWaterfall-PowerBI/blob/master/Beta%20Version/SimpleWaterfall_dev.2.0.10.2.pbiviz?raw=true

Let mr know if you find any issues

Thanks Nishant

On 13 May 2020 at 16:33, perezcotai notifications@github.com<mailto:notifications@github.com> wrote:

let me know if you need help for test

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHubhttps://github.com/nishantjainuk/SimpleWaterfall-PowerBI/issues/11#issuecomment-628070084, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AF26VJKOPZCNXYFQYYU5P5LRRK4UBANCNFSM4LXCSWJA.

[perezcotai]

The "fit to width" work only with horizontal chart but fail with vertical chart. Then, I get extra decimals numbers as you see in the bellow chart.

[perezcotai]

Let me know if you need help to test

[nishantjainuk]

@perezcotai

I fixed a lot of issues when I released the last version in May earlier this year. But I am not sure if I have fixed all the issues you suggested. I am closing this issue as it is quite old but can you create new issues if you still have any left.

I have got some time now to continue my work on this visual and would be glad to fix some of your issues.

Looking forward for more issues from you.