Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good day!
I have a scatter plot (showing a 'sunbeam' type of roadmap) based on a table, with in the report a number of filters on the table.
Depending on the filters applied in the report, I want to re-calculate the position of dots on the scatter plot to spread them according to the new number of items.
Question is: how do I get the total of the filtered rows into a measure?
Hey,
I have e.g. the data like this:
Country | Dept | Value in $ | Order | X | Y |
BE | Dept a | 4 | 1 | ||
BE | Dept a | 6 | 2 | ||
BE | Dept b | 10 | 3 | ||
FR | Dept C | 3 | 4 | ||
FR | Dept b | 5 | 5 |
I want to have a scatter plot that shows the filtered data spread in a sunray type of way.
X and Y values are direct input to the x and y for the scatter plot.
X = COS(RADIANS(270 - 90 *(Order / Total)
Y = SIN(RADIANS(270 - 90 * (Order / Total)
With total = 5 (i.e. the total number of rows)
And with "Order" column calculated automatically
Problem is: I want to have a filter next to the scatter plot to filter e.g. on Country = FR. At that point, I need to have Order and Total dynamically re-calculated:
Total = 2 (as I have 2 lines left after the filtering on Country = FR)
Order needs to update as well, showing nothing in the first 3 lines and 1 and 2 in the two bottom lines.
The scatter plot needs to be updated accordingly as well, taking into account the newly calculated X and Y value.
I starting to doubt that all of this is actually possible 🙂
Thanks,
Wim
User | Count |
---|---|
84 | |
69 | |
69 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |