PowerBI - how to show percentage calculation of aggregate AND segments on line chart

Hi, I'm a beginner to PowerBI and just learning by doing, looking for youtube videos etc. I do not know DAX or any coding at the outset.
I'm trying to learn quickly for a deadline so please suggest simple solutions with minimal or simple coding please!

On my sample spreadsheet I'm dealing with the yellow highlighted fields. There's s 'picture' of the result I want to get to. How can I:

1) Show a line for 'All' (the Total) AND for each Gender. I can only seem to get just Male and Female alone

2) I am filtering on 'Pass' just to show the 'Pass' but only getting the values. But what I want to show is the % passed out of the total cohort for each year. So for 'All' the Total % Passed out of all each year and for each Gender, the % Passed from each Gender total each year. And show everything Year by Year in a time series

Do I need to do calculations in Excel first or can I/should I do it all in PowerBi and how?! Thanks

look here: https://learn.microsoft.com/en-us/power-bi/

Thanks for replying - and for link, very useful. Over more time, will be learning. Any immediate helps though with specifics now greatly appreciated as I've been on youtube all day but not making headway!

PowerBI is Power Query and Power Pivot together

I'll re-read your post but not promising, maybe someone else
I suggest PowerBI forum

try https://community.powerbi.com/t5/Des...er-bi-designer

Great, let me have a look...

try to adapt this code to Power Query in PBI
this is the same language : M

Please Login or Register  to view this content.

Hhhmm ok, let me take a look.

...Let me take a look, thank you.

You are welcome

Will update on final result tomorrow! ..

Tomorrow is just today Good morning

Haha yes

Originally Posted by sandy666

try https://community.powerbi.com/t5/Des...er-bi-designer

@Sandy666: Thanks soooo much for all the above tips + site suggested = solved!

Glad to help

if you are happy hit Add Reputation