I am using a measure select approach to enable user to switch between values within one chart. Some of the measure included require a different format (e.g. percentage or decimal). In the using Switch calculated Measure_Select Measure some values don't show in charts, but in tables when vizualising the data.
I don't think this is due to the measure select methode but more to the way how I am defining decimal or percentage format for some of the values. I have also created a plain calculated measure independetly from the Measure Select methode and have the same issue.
The calculation I am using is for eample: Measure = VALUE(FIXED(SUM(Metric1)/SUM(Metric2)))
This should return a decimal with 2 digits in a table but does not render in a line chart for example.
I also received this error: "The SampleAxisWithLocalMinMax function requires Measure parameter... to be a numeric columns reference from the specified table"
Feedback Type: Frown (Error)
Local Time: 2020-04-24T09:23:52.8803495+01:00
Release: March 2020
Product Version: 2.79.5768.1082 (20.03) (x64)
OS Version: Microsoft Windows NT 10.0.17763.0 (x64 en-US)
CLR Version: 4.7 or later [Release Number = 461814]