Forum Discussion
Dynamic radar visualization based on multiple input parameters
- 3 years ago
Hi Anonymous
The what-if numeric range parameter has a limitation that it has a data point sampling limit. Once the number of data points gets above the limit, it snaps input to "known" values in the sampled data. The current limit seems to be 1000, while your parameter has 10001 data points, which is greater than 1000. That's why you met the behavior described in question 1. You will also see the following information when it hits the limitation:
There is no workaround to solve it currently, you could vote up the following idea about this limitation:
Microsoft Idea: "what if" parameter - turn off sampling so all numbers are generated in a range
Or consider if it is possible to increase the increment to reduce the data points.
Reference:
Use what-if parameters to visualize variables - Power BI | Microsoft Learn
========================================================
For question 2, you can create a measure similar to below to get the expected values from four parameters, then add this measure to the radar chart. Once you create a numeric range parameter, it automatically creates a measure for you. You can find that measure below the corresponding parameter table in Fields pane.
Expected = SWITCH( SELECTEDVALUE('Table'[Name]), "Metric A",[Metric A], "Metric B",[Metric B], "Metric C",[Metric C], "Metric D",[Metric D] )Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi Anonymous
The what-if numeric range parameter has a limitation that it has a data point sampling limit. Once the number of data points gets above the limit, it snaps input to "known" values in the sampled data. The current limit seems to be 1000, while your parameter has 10001 data points, which is greater than 1000. That's why you met the behavior described in question 1. You will also see the following information when it hits the limitation:
There is no workaround to solve it currently, you could vote up the following idea about this limitation:
Microsoft Idea: "what if" parameter - turn off sampling so all numbers are generated in a range
Or consider if it is possible to increase the increment to reduce the data points.
Reference:
Use what-if parameters to visualize variables - Power BI | Microsoft Learn
========================================================
For question 2, you can create a measure similar to below to get the expected values from four parameters, then add this measure to the radar chart. Once you create a numeric range parameter, it automatically creates a measure for you. You can find that measure below the corresponding parameter table in Fields pane.
Expected = SWITCH(
SELECTEDVALUE('Table'[Name]),
"Metric A",[Metric A],
"Metric B",[Metric B],
"Metric C",[Metric C],
"Metric D",[Metric D]
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
- Anonymous3 years agoNot applicable
Thanks for your suggestions and instructions. I have already applied those (and updated a little bit) and they solved perfectly my problems. Thanks a lot.