cancel
Showing results for 
Search instead for 
Did you mean: 

DAX Measure with FIXED function not showing in charts

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)

Timestamp:
2020-04-24T08:23:52.8803495Z

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]

Peak Virtual Memory:
42.2 GB

Private Memory:
3.22 GB

Peak Working Set:
2.53 GB

IE Version:
11.379.17763.0

Workbook Package Info:
1* - en-GB, Query Groups: 4, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Is Report V3 Models Enabled:
True

Enabled Preview Features:
PBI_NewWebTableInference
PBI_qnaLiveConnect
PQ_AIInsightsFunctionBrowser
PBI_realTimeRefresh
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_v3Models
PBI_themeDialog
PBI_hierarchicalSlicerCreation

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_decompositionTree

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
150%

Supported Services:
Power BI

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @frankg

 

I'm not able to reproduce the issue on my side. Please provide a pbix file if possible. Please remove sensitive data in the report, upload pbix file to your OneDrive for Business then paste the share link here. 

 

Best Regards,
Qiuyun Yu