remove data from x axis if no data.

[jcastr02]

I have module exams that team members have taken, not all modules have the same number of questions.  I'd like the x axis to show the questions that are specific to it, so if first module has 36 questions. , only questions 1-36 should show, currently there is space showing and I'd like to remove it ..

[dax]

Hi @jcastr02 , 

It seems that you use other table's column as Axis, right? If so, I think you could use fact table directly in axis instead of refer to other table's column as axis. If possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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

[amitchandak]

@jcastr02 , for Both Avg Score and Score make the 0 value as blank of filter 0 rows at the visual level

Avg Score1 = Calculate([Avg Score],not(isblank([Avg Score])),[Avg Score]>0)
Score1 = Calculate([Score],not(isblank(Score])),[Score]>0)

[Greg_Deckler]

Difficult to say without sample data but I am thinking that perhaps you need to change the direction of your relationship to Both instead of Single?