Forum Discussion

LYeo87's avatar
LYeo87
Icon for Helper II rankHelper II
5 years ago

Visual Help

Hi Have 2 graphs - the 1st is showing me the percentage of jobs over the year - so for example Dec equals 40.94%.   I then have a second graph that shows me these jobs broken down into 2 x categori...
Need Help
Show and Tell
Anand24's avatar
Anand24
Icon for Super User rankSuper User
5 years ago

Hi LYeo87 ,

 

Can you please provide sample data and expected output?

You will need to use either of ALL, ALLSELECTED or ALLEXCEPT in your DAX but which one to use will be based on your data.

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

LYeo87's avatar
LYeo87
Icon for Helper II rankHelper II
5 years ago

Top graph is used with a new column - IF statement. Buttom is purely totals 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi LYeo87 ，

    Could you please share some sample data and applied fields/measures on your two graph in order to provide you a suitable solution? If there is any measure applied on the graph, please also provide the related formula. Thank you.

    In addition, I created a sample pbix file(see attachment) for you. Please check whether that is what you want.

    Best Regards