Forum Discussion

ThomasDay's avatar
ThomasDay
Impactful Individual
8 years ago

Measure for Scatter Plot Category

Hello All,

 

Seems like this has probably been hashed out--and perhaps solved.  I didn't see anything and thought it might be a straightforward Yes/No and perhaps a "here's how."

 

I have a scatter plot where I use a Column for Details, Measure for the X and Y axis, and cannot for the life of me use a column measure for category.  The bin just doesn't accept it when I drag it over.  It takes a column from the table I'd like to build a measure from but I can't get it to take a measure.

 

 

 

 

 

 

 

 

 

 

 

 

The Details is a column: MeasureReptRecNoProviders[Facility]

X-Axis is a measure: Denominator = IF([DenomVariablesRecCount]= 1 ,AVERAGE(Denominators[Variable_Value]),BLANK())  So it's picked from a slicer.

 

Y-Axis--same thing: Numerator = AVERAGE(MeasuresData[Variable_Value])

 

For Category, I've tried a simple: ChartCategory = MINA(MeasureReptRecNoProviders[SystemName])  and no go.  (Note, It's in the same table as the Details column.  If I can put a measure there, I'll pick the category field from a slicer.

 

Any ideas?

Thanks,

Tom

Need Help

7 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Tom,

     

    If I understand your scenario correctly, you'd like to add a measure in the "Details". I'm afraid we can't do that. That's because the "Details" is the context of other measure. What's the result do you expect?

     

    Best Regards,

    Dale

    • ThomasDay's avatar
      ThomasDay
      Impactful Individual
      8 years ago

      Hi Dale--I'm looking to add a measure to the Legend bin...that wasn't clear at all..sorry for the confusion 

       

      Right now I've put "bed size" in there which is from the same table as Facility (Details) which sets the context. 

       

      I'd like to use a slicer to select data from one of about 7 different columns--all from the same table as the Details field of Facility.  

       

      Here is an example of How I thought I'd do it but the bin for Legend does not seem to accept a measure.

      ChartCategory =
      VAR CatToUse = IF(HASONEVALUE(Category[Chart Category]),SelectedValue(Category[Chart Category]),"Bed Size")
      Return
      IF(CatToUse = "System Name",VALUES(MeasureReptRecNoProviders[SystemName]),VALUES(MeasureReptRecNoProviders[Bed Size]))

       

      Does that help?  Any ideas?

      Tom

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi ThomasDay,

         

        How about using a calculated column instead of a measure? Can you share a sample? Maybe we can find a solution.

         

        Best Regards,

        Dale