Forum Discussion

PBI_Rookie's avatar
PBI_Rookie
Helper I
4 years ago
Solved

Control Charting-ALLSELECTED

Hello All,   I've previosuly created control charts using a dataset with only the data needed. I am now trying to use the same measures to create the control charts where the data needed is only a ...
Need Help
  • PBI_Rookie's avatar
    PBI_Rookie
    4 years ago

    I was finally able to get this to work. 

     

    I used AllSELECTED as I described initially. What I had to do to make it work however was to duplicate my source table and filter it to be only the needed information. In this case the sample IDs. 

littlemojopuppy's avatar
littlemojopuppy
Community Champion
4 years ago

Hi!  Try changing ALLSELECTED() to KEEPFILTERS(Identifier I want to sort by]).

PBI_Rookie's avatar
PBI_Rookie
Helper I
4 years ago

Hi, 

 

Ok I tried replacing the ALLSLECTED in both measures with KEEPFILTERS. I get an error that "Cannot convert value (identifier) of type TEXT to type True/False"

 

 

  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion
    4 years ago

    😮  Well that is certainly an unusual error message...

     

    Can you provide some sample data to play with?

    • PBI_Rookie's avatar
      PBI_Rookie
      Helper I
      4 years ago

      Playing with KeepFilters a bit I can see why it is giving me that error. If I alter it a bit i.e. KeepFilters(Column="") i will not get the error. Unfortunately it also does not solve the initial issue. 

      • littlemojopuppy's avatar
        littlemojopuppy
        Community Champion
        4 years ago

        I think I was a little off...try KEEPFILTERS() with whatever is on the X axis