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,
I have a scatterplot that shows all data points from a data set.
For this scatterplot i have one filter at the moment, this is used with conditional formatting to highlight the choice of set filter in the scatterplot.
Now, in total i have 2 dataset (unfortunately i cannot share the datasets), one that has a fixed duration variable, on that does not have a fixed duration variable.
The idea is as follows:
- for the scatterplot i want the highlighted variable (choice in filter 1) to change when a different duration is chosen.
- The other variables that have not been chosen in want to still have the fixed duration, so they don't change whenever i select a different duration option.
- in short, i want my highlighted (chosen variable in filter) to change when an option in the duration filter is selected and the "non-chosen" variables to not change.
Is this doable with DAX or in any other way?
(i think this will be a DAX problem, thats why i posted it here)
I am thinking of some sort of way that the highlighted variable will come from the "non-fixed" duration dataset, and the other "non-selected" variables will come from the "fixed" dataset.
Is there a way to accomplish this?
Some more information with screenshot of the scatterplot:
The blue dot is my chosen company, the green dots are other companies that have not been chosen in the Company filter.
Now i have another filter called Duration
With this Duration filter i want to be able to filter the blue dot, and the blue dot only.
If another company is selected in the company filter, i now want for only that company to be affected by the duration filter and no other company
Unfortunately I cannot share the data as it is private. I can however share a screenshot of the scatterplot if this would help?
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |