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
Astro1990
Frequent Visitor

Using 2 Date Slicers for same graph

Hi,

I am trying to replicate 2 histograms under same graph, that can be controlled by 2 date slicers. Simply to see a before and after, while keeping all the data.

First I copied the current data that I have into a new table.

DateAge FreqAge BinLegend
17/10/2022184053,21
17/10/2022123556,41


In the 2 tables that I now have, I only added legends and changed the date on one of the tables

 

Date(2)Age FreqAge BinLegend
17/10/2022184053,22
17/10/2022123556,42



Then appended the 2 tables to look something like this

DateDate(2)Age FreqAge Bin Legend
17/10/2022  184053,21
17/10/2022 123556,41
 17/10/2022 184053,22
 17/10/2022 123556,4 2


The graph looks like what I want, but the slicers are not really working when I am moving the earliest date. 
Am I way overthinking this? Any help would be greatly appreciated 🙂

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @Astro1990 ,

 

The two tables are still merged in the same way as above, but the distinction between the data in the two tables depends on the legend field rather than the date field. So creating a dummy table with a legend field as a slicer might achieve what you need.

vhenrykmstf_2-1666768219755.png

vhenrykmstf_3-1666768881589.png

vhenrykmstf_4-1666768893006.pngvhenrykmstf_5-1666768902927.png

 


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-henryk-mstf
Community Support
Community Support

Hi @Astro1990 ,

 

The two tables are still merged in the same way as above, but the distinction between the data in the two tables depends on the legend field rather than the date field. So creating a dummy table with a legend field as a slicer might achieve what you need.

vhenrykmstf_2-1666768219755.png

vhenrykmstf_3-1666768881589.png

vhenrykmstf_4-1666768893006.pngvhenrykmstf_5-1666768902927.png

 


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Astro1990
Frequent Visitor

Hi, I really appreciate the answers, but I do need 2 different slicers controlling the graph.  

AgeBin.jpg

I tried attaching what I am trying to replicate. Date Slicer (Yellow) need to controll full data under the legend without interfering with the (Green graph). 

So that's why I thought just appending the 2 data sets and giving them different dates in the columns. 

Is this even possible? Thank you so much in advance!

Ashish_Mathur
Super User
Super User

Hi,

Rename Date(2) to Date and then append.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Shaurya
Memorable Member
Memorable Member

Hi @Astro1990,

 

I don't think there is a need to to create two columns for date. Just append the rows from table 2 below table 1. Since they have similar structure, the operation can be easily done and you'll be able to use the slicer.

 

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.