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,
I have a report where I want to create an overview of Dynamics CRM opportunities in different categories for different customers. I want to have a list with customers names where the names are conditionally formatted based on whether they have an opportunity in a given category or not. It is important that I am able to slice on opportunity categories.
To Exemplify:
The report consists of a opportunity category slicer and a table with customer names. If I select a category, for instance Digital Building, the table should be updated such that all customers are visible, but only the customers who have one or more Digital Building opportunities are colored by conditional formatting. The same applies if I select another category, for instance Internet Telephony. I have tried to do this, but I have to create one measure for each opportunity and have one page per opportunity category. This is not an acceptable solution since we have very many categories.
Any suggestions?
+1 to the thread,
Im interested in that function
🙂
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |