Forum Discussion

spotpuff's avatar
spotpuff
Frequent Visitor
9 years ago
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...
Need Help
  • spotpuff's avatar
    spotpuff
    9 years ago

    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.

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

spotpuff,

 

It's not very easy to reproduce this issue. So could you please share us the .pbix file?

spotpuff's avatar
spotpuff
Frequent Visitor
9 years ago

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.