Forum Discussion
Solved
Format causing measure to return blank.
I'm using a measure with disconnected slicers to return a value depending on how the user interacts with the report. They can choose to view values as values or percentages, and can choose from 3 mea...
I can't share the file but I will work on building a comparable file that has the same data model layout and see if I can reproduce the issue.
I just tested the histogram bucketing and formatted measure in a table (rather than just a bar chart with labels) and it works fine, so now I don't know why it's not working properly with the bar chart. I believe the issue is that FORMAT() returns a text value, which the bar chart doesn't know is actually textual representations of numbers.
Format function returns empty instead of blank.
So try following
Var A= FORMAT ( AVERAGE ( 'Delivery'[ShelfTime] ), "HH:MM:SS" )
Return if (A & "--" == "--" , blank(), A )