cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Help with showing all values from the slicer instead of adding their values

Hi,

 

I have created this visualization that shows all the years for various regions. I also have a slicer showing wave 1 and wave 2. We would like to see both the waves in this visualization. 

kamsingh11_0-1603980967078.png

kamsingh11_1-1603981082205.png

 

Right now, it only shows either for wave 1 or for wave 2 based on the selected slicer. If we do select all, then it adds up the values for wave 1 and 2. However, we want to see both waves 1 and 2 along with years as we have it for all the regions. Is it possible to see both the waves with years?

 

Thanks for your help!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

Hello @kamsingh11 ,

As far as I know, the only way to have double dimension axes is to use the drilldown function.

In his scenario, he would have Country as an axis, then Wave just below him, also as an axis. When no drillthrough is used, the chart will work as described. However, clicking the forked down arrow on the drillthrough buttons will break down into the Country and Wave axes, showing what I think you need.

For example:

BA_Pete_0-1603981974216.png

Both charts have the values populated in the same way. The first as without getting details selected, the second has this selected:

BA_Pete_1-1603982036147.png

View solution in original post

5 REPLIES 5
Highlighted
Super User I
Super User I

Hello @kamsingh11 ,

As far as I know, the only way to have double dimension axes is to use the drilldown function.

In his scenario, he would have Country as an axis, then Wave just below him, also as an axis. When no drillthrough is used, the chart will work as described. However, clicking the forked down arrow on the drillthrough buttons will break down into the Country and Wave axes, showing what I think you need.

For example:

BA_Pete_0-1603981974216.png

Both charts have the values populated in the same way. The first as without getting details selected, the second has this selected:

BA_Pete_1-1603982036147.png

View solution in original post

Highlighted

Thank you so much!

For now it works! I was actually looking for same year and both waves. So, 2017 Wave 1, 2017 Wave 2, 2018 Wave 1, 2018 Wave 2, and so on... Can we do that? Otherwise this is definitely a good option.

Thanks for your help! I highly appreciate it!

Highlighted

@kamsingh11 You can try below

 

negi007_0-1603987304591.png

 

 

Highlighted

@kamsingh11 ,

I think you might have to adjust the chart axis sorting, although can't be sure this will work for you in this instance:

BA_Pete_0-1603987341017.png

Pete

Highlighted

Thank you! This is also a good way of representing. But I was actually looking for Wave 1 and 2 side by side for the same year per region such as 2017 wave1, 2017 wave 2, 2018 wave 1, 2018 wave2 for UK on x-axis.

 

Thank you!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors