Line and Stacked Column Chart using distinct count X-Axis

[Auski]

Hi all,

Having somewhat of an issue here. I'm just at the validation stage so playing around with visuals and wondering if there is something that can be done with the below graph?

I want each column to be grouped by conversation id, but don't want the id to be shown as outlined above. A conversation ID consists of multiple rows of data which is why the graph needs to be visualised this way.

Doing a distinct count of conversation ID doesnt work as numbers cannot be added to the X-axis so maybe there is a way using DAX???

The DAX I am currently using is :

Line Y-Axis
Plan % =

CALCULATE (

    DIVIDE( [Score], [Total Result Score] ),

    FILTER (

        'Results Table',

        SEARCH ( "Plan", 'Results Table'[Question Group], 1, BLANK () )

    )

)

Column Y-Axis
Total Score % =
CALCULATE ( MAX ( 'Results Table'[answerstotalscore] ) / 100 )

I am using a date slicer and some other filters, but besides this it's a very straight forward visual.

Anyone have any genius ideas?

[Ritaf1983 · Accepted solution]

Hi @Auski 
If the problem is just the ids that you don't want to show, switch off the option of X-axis values from the format options.

if it is something else 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

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

[amitchandak]

@Auski , There is an option Concatenate Label - You can play with that switch or/off.

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.