Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi ladies and gents,
I'm not sure this is possible, but it would be amazing if it were.
So, I'm having this huge table on Leads, and within I have FOUR separate date columns:
- Created Date
- Change Date
- Moved Date
- Closed Date
I'd like the users to select a period in ONE date visual (say, last 7 days), and the report to display the number of Leads:
- Created
- Changed
- Moved
- Closed
in that period, in separate visuals.
Please please help.
Best,
Alice
Solved! Go to Solution.
@AliceW ,
You can unpivot these 4 columns using power query. So you have 1 column for date and other for "date event"...
you can use a slicer for this date column and filter what you need, even interacting with other visuals.
Hmmm, I'm not sure what you mean by unpivoting. They are different columns at the moment...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |