Forum Discussion
How to create a visualization for a measure
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".
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
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?
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 YuIt's ok - I've been working with Oakwood Systems out of Kansas City and they have told me what I want to do it not possible. I can't seem to place a measure into a visual to break the data on it. Instead, I'll work with my users to give them a few likely scenarios and build those filtered views in SQL Server and then serve those up to them in different visuals. Thanks for trying to help me.