Forum Discussion

Kavya123's avatar
Kavya123
Icon for Helper III rankHelper III
5 years ago

Unable to Visualize Measure

Hi Everyone,

 

I am unable to show measure in bar chart.  I need to use format for my calculation. Please help

 

if(HASONEVALUE(Merge1[ResponseType]),format( divide(CALCULATE(SUM(Merge1[Value]) ,FILTER(Merge1, Merge1[Benchmark (2).iIdConsortium]= 52) ),100),FIRSTNONBLANK(Merge1[ResponseType],1)) , sum(Merge1[Value]))

 

 

 

 

Need Help
Tips and Tricks

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Kavya123 , is format function is going to convert this into text. because if the data type is text, you might not able to use the same on the bar.

    • Kavya123's avatar
      Kavya123
      Icon for Helper III rankHelper III
      5 years ago

      Thanks for your response. But, I need to format the data based on the field response type. Please let me know if we have  any other option

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

        Kavya123 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Kavya123's avatar
      Kavya123
      Icon for Helper III rankHelper III
      5 years ago

      Response type, Value,Year,Name,Output

      ##0,  44,  2018  , A, 44

      ###,###,###,##0%,  50.6,  2018,  B,  51%

      ###,###,###,##0.0,  66.87,   2019, C, 66.9

      ###,###,###,##0.0%, 10.7, 2020, D, 10.7%

      ###,###,###,##0.00%, 30.55, 2020, E, 30.55%