Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Date | Age Freq | Age Bin | Legend |
17/10/2022 | 1840 | 53,2 | 1 |
17/10/2022 | 1235 | 56,4 | 1 |
In the 2 tables that I now have, I only added legends and changed the date on one of the tables
Date(2) | Age Freq | Age Bin | Legend |
17/10/2022 | 1840 | 53,2 | 2 |
17/10/2022 | 1235 | 56,4 | 2 |
Then appended the 2 tables to look something like this
Date | Date(2) | Age Freq | Age Bin | Legend |
17/10/2022 | 1840 | 53,2 | 1 | |
17/10/2022 | 1235 | 56,4 | 1 | |
17/10/2022 | 1840 | 53,2 | 2 | |
17/10/2022 | 1235 | 56,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 🙂
Solved! Go to Solution.
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.
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.
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.
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.
Hi, I really appreciate the answers, but I do need 2 different slicers controlling the graph.
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!
Hi,
Rename Date(2) to Date and then append.
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