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.
I have a situation where I want the date axis of several visuals to automatically adjust depending on what customer is selected and the date they came online. The visual in question is showing a count of new hires (employees who have a start date in a given month).
The table feeding that is the company's entire employee roster, going back many years. However, if the customer just started with us this year, I want the x-axis (date) on the visual to be only go back to the customer's start date (which I have in the Customers table), and ignore all the earlier hires from the employee roster.
I have page-level filters for customer. If I change which customer is being shown, I want the date axis on these visuals to change automatically depending on the customer's start date.
I don't want to exclude earlier employees from the roster data during queries/data ingestion; I still want the full roster for other uses. But I also need it dynamically constrained by customer start date in certain contexts. What would be the best approach?
Hi @rogersmj ,
Could you please share your sample data and excepted result to me if you don't have any confidential Information. Please upload your files to One Drive and share the link here.
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 |