Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
I have a table with ticket information with Created and Resolution Date.
The customer would like to see two charts in one page, with a creating and a resolving trend.
It's pretty simple, but they would like to have only one slicer, where you can set the timeframe.
I thougt its a good idea to connect the two slicer, then if they modify the created date the resolution date will adapt also.
My problem:
They select to show the tickets from 2023-10
I have a ticket where:
Table: Ticket_List
Ticket ID | Created Date | Resolved Date |
1234 | 2023-09 | 2023-10 |
As the two slicer has the same value (Created >2023-10 and resolved > 2023-10), the second chart wont show this ticket as it doesnt fit for the created slicer.
Goal:
Slicer: show the tickets after 2023-10 date
Created chart: wont show the '1234' ticket
Resolved chart: Show the ticket in october.
Is there any way to solve this or this is simple just not possible, and we should stick to the different slicer solution?
Thanks,
Daniel
You might need a role playing dimension table, please see the tutorial below. hope this helps.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
75 | |
60 | |
37 | |
33 |
User | Count |
---|---|
102 | |
56 | |
52 | |
45 | |
40 |