Forum Discussion

royces99's avatar
royces99
Frequent Visitor
2 years ago
Solved

Displaying Individual values and Percentiles - Line Chart

I want to create a line chart that shows, on the x axis the Stage (4 stages) and shows the number of Findings on the y axis.  It needs to show the lines for individual Projects and the 80th Percentile line for the Projects selected.  I have created the DAX measure for the 80th Percentile and the data displays OK (and correctly calculated, code below) in a Matrix format but I cannot present the same information on a line chart.  I can only get the line chart to display an aggregate of the selected Projects and the Percentile line.  

Is there a way to do this?  Have tried creating a CombinedTable but that generates an error message "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

I'm stuck.  Please help!!

 

DAX for 80th Percentile: -

 

80th Perc 5 =
VAR CurrentLCStage = MAX('Findings raised by Project'[LC Stage])
RETURN
PERCENTILEX.INC(
    FILTER(
        ALLSELECTED('Findings raised by Project'),
        'Findings raised by Project'[LC Stage] = CurrentLCStage
    ),
    'Findings raised by Project'[Findings],
    0.8)

 

Need Help
  • royces99's avatar
    royces99
    2 years ago

    Yeah, I got the same level of help from Google.  For anybody else encountering this, I eventually found that changing the visual to a bar/ line combo chart worked with the individual Projects depicted as bars and the percentile values as lines (I also added 20th and Median in the same way).  

2 Replies

  • royces99's avatar
    royces99
    Frequent Visitor
    2 years ago

    Yeah, I got the same level of help from Google.  For anybody else encountering this, I eventually found that changing the visual to a bar/ line combo chart worked with the individual Projects depicted as bars and the percentile values as lines (I also added 20th and Median in the same way).  

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi royces99 ,

    The error message you're encountering, "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value," typically occurs when a DAX expression intended to return a single value instead references multiple columns. This can happen in scenarios where the context of the calculation isn't correctly defined for the visualization you're attempting to create.

     

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.