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 All,
The chart below contains a measure with the distinct count of Customers & the Legend is Product:
Current Customer Uptake =
CALCULATE(
DISTINCTCOUNT(DATA[Customer),
LASTDATE(DATA[LAST_DAY_OF_WEEK]))
Each product has a unique go live date and is used to calculate the X asis "Weeks from go live" within a custom column.
Problem:
I would like to select a particular data point in this chart and see the increase/ decrease of customers within a table format, see image below. However, when a particular data point is selected the previous weeks data disappears.
What is the best way to calculate/visualise this? Suggestions welome 🙂
Refer to my file which uses rank to find Last week
https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |