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.

Dog's avatar
Dog
Responsive Resident
9 years ago

spotpuff

 

you're not kidding, I went round in circles on this one. 

 

the only thing I had considered although never followed it through was to have a stacked bar graph that has two outputs one for percentage values and one for the numerical values. 

 

depending on slicer selection would depend on which one had data in to show on the graph - I'm assuming that it would then allow you to format the measures independently. 

 

If I give it a go I'll let you know. 

 

Dog

spotpuff's avatar
spotpuff
Frequent Visitor
9 years ago

Dog That's an interesting idea; let me know if it works. I wonder if the "auto" scaling for the chart is "smart" enough to switch between Percent and General (with scaling) if you do this!