Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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
BA_Pete
Super User
Super User

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

5 REPLIES 5
BA_Pete
Super User
Super User

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Anonymous
Not applicable

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!

@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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




@Anonymous You can try below

 

negi007_0-1603987304591.png

 

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Anonymous
Not applicable

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.