Forum Discussion

ThomasDay's avatar
ThomasDay
Icon for Impactful Individual rankImpactful 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 scatt...
Need Help
ThomasDay's avatar
ThomasDay
Icon for Impactful Individual rankImpactful 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
Icon for Microsoft Employee rankMicrosoft 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

  • ThomasDay's avatar
    ThomasDay
    Icon for Impactful Individual rankImpactful Individual
    8 years ago

    That's a good idea.  I've not created a column before...just scalars.  Are you thinking of SelectColumn?  And with SelectColumn, do the relationships from the base table stay in-place when it is executed?  Thanks, Tom

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

      Hi Tom,

       

      If they are all scalars, I think the calculated column could be the best solution. Please give it a try. If you use SELECTCOLUMNS in a measure, that still won't work.

       

      Best Regards,

      Dale

      • ThomasDay's avatar
        ThomasDay
        Icon for Impactful Individual rankImpactful Individual
        8 years ago

        v-jiascu-msft Oh, I get it now...I'll try that.  Am traveling a bit and will report back when I give it a try.  Thank you, Tom