Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

How to create a visualization for a measure

I have run into a brick wall. I'm new to Power BI, but I really would like to be able to show my users something. Here goes: I need to be able to create a visualization that will update based on a me...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi Anonymous,

 

If MattAllington's suggestion doesn't meet your requirement, please share some sample data and screenshots about the expected results, so that we can test it in our environment.

 

Best Regards,
Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
10 years ago

My problem is that I want to use the new measure, "Filtered.CEMI-x" as a split for the pie sections. I want to know how many customers have seen exactly 1, 2, 3, 4, ...x interruptions based on the filtered data. I don't want to use the measure or the calcuated column in the values section of the visual.  Power BI won't let me place my measure (that updates when users select various slicer configurations) as the "Legend" or "Details" field of the pie chart. I really don't care to use the calculated column because the measure is what gives me the breaks I want on the data, but I can't get Power BI to allow measures to be used as splits in visuals.   Please see the screen shot that shows a slicer selection that has changed the measure "Filtered.CEMI-x" from it's orginial values shown in the calculated column "CEMI-x".

 screen shot

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    10 years ago

    Hi Anonymous,

     

    According to your description, it seems that you want to place a measure in Legend or Details property within a pie chart visual, right?

     

    The measure returns the aggregated value from a expression, so it can't be used for categorizing pie chart values. In your scenario, you can consider to convert the measure Filtered.CEMI-x to a calculated column, then place this column in Legend or Details property.

     

    Best Regards,
    Qiuyun Yu

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Your suggestion is exactly what I had already done and it doesn't change when slicers are applied.  The column I made was called "CEMI-x" and is in the screen shot I provided.  It is not correct when a user filtered the data based on a slicer.  In the screen shot, I want to show CEMIs of 2 and 3, not 10 and 11 like the pie chart shows.

       

      Is there anything I can do to get this corrected?

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        10 years ago

        Hi Anonymous,

         

        Would you mind sharing .pbix file for our analysis? So that we can try to check if the requirement can be achieved.

         

        Best Regards,
        Qiuyun Yu