Forum Discussion
Custom base values in highlight function
Hello
Apologies if this has been answered before, but I have a hard time finding an answer or relevant topic to search for.
In short, I want to be able to have the highlight function of the column/bar/funnel chart, to have a different base value to compare with instead of the total of the dataset.
I have a customer database consisting of 1.500.000 rows of customers, with about ~450.000 active customers. There is all sorts of demographic information, segments etc.
Example:
Let's say I make a dashboard of aquired customers 2017. I make slicers so the users can select dates/months, customer types etc.
If I then make a funnel chart of an age group segmentation in percentage of total, it will then highlight the total of 2017 behind when selecting a specific month(s).
This is a feature which I see great potential in, for finding anomolies at a glance that can be deep dived further into.
What I want, is to be able to chose the data that the bar/pie/funnel highlights behind - not the total data of the dataset. I want this, because I want to be able to compare it with my current active customers or any other base I might see fit to compare it with.
If anyone have any examples of a better way to implement this comparison in Power BI - then I am all ears and welcome suggestions :)
Best regards
David
4 Replies
Hi DavidB,
What I want, is to be able to chose the data that the bar/pie/funnel highlights behind - not the total data of the dataset. I want this, because I want to be able to compare it with my current active customers or any other base I might see fit to compare it with.I'm not sure I can understand your requirement totally. Could you be more precisely with it by posting some sample data and screenshots? So that we can better assist on this issue. :smileyhappy:
Regards
Hello v-ljerr-msft
Thank you very much for replying.
So you know when you make a simple funnel chart, you can go in to: Visual tools > Format > Edit interactions.
After that, you can select to "Highlight" on how the chart acts when slicing/selecting data in the report.
Then in the background of the funnel, the original total will be a bit transparent and the sliced/selected data will be the new funnel.
That way, it is easy to compare two totals on top of each other.
In my case, I want to be able to set/control the transparent part - i wan't the "base" to be a static amount always, that I have chosen, not the total of the dataset I'm working with.
I hope you can understand what I mean, and it probably isn't possible now that I think more of it.
But I would very much welcome any other suggestions on how to easy compare data that is sliced/selected with a static amount I set beforehand.No dice? :)
If my "problem" can't be solved - can anyone recommend a nice way to show my customer base numbers compared to fixed population numbers?
