How to have data category appear on line y-axis instead of column y-axis in combination chart?

[powerjey]

Hi everyone,

Currently I have all my data in 2 columns - qty & resource_type.

resource_type falls into 3 categories - supply, net requirements and project balance. 

Is there an easy way for me to split the supply and net req to column y-axis while the project balance goes to the line y-axis?

There are 1mil+ rows so the solution would need to be decently efficient. 

Not sure where to start on this so any help would be appreciated! I tried to merge a duplicate table containing only project bal. qtys onto the original table so there would be a seperate column to drag into the line y-axis data field, but the query was taking far too long. 

[Anonymous · Accepted solution]

Hi @powerjey,

Did you mean to add custom legends on the chart to show the analysis results? If that is the case, you can create a new table with the original table category and new analysis category types.

Then you can use this field on the chart legends field, and writer a measure formula to lookup raw table value based on the current axis and legends category. For the new custom field types, you can write the custom formula to replace their calculation.

My Favorite DAX Feature: SELECTEDVALUE with SWITCH | Winston-Salem Power BI User Group (pbiusergroup...

Solved: Re: DAX SWITCH + SELECTEDVALUE() - Microsoft Power BI Community

Regards,

Xiaoxin Sheng

[amitchandak]

@powerjey , Not Very Clear. But refer if this can help

Calculation Groups - Use Measure with small multiple : https://www.youtube.com/watch?v=LEn6ZnScMZc