Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Hide months without values

I have several graphs created for different project dashboards that contain an assortment of different data. At the moment, they are displaying several months with and without values such as seen in ...
Show and Tell
Tips and Tricks
Tutorial Requests
  • ray_aramburo's avatar
    ray_aramburo
    2 years ago

    No problem! Open this pane:

    Then you can perform something like this:

     

    Keep in mind that you need to have the chart selected to have those cards there.

     

  • ray_aramburo's avatar
    ray_aramburo
    2 years ago

    Apply that same filter in the Count of Course Code card, not in the Month card. That should do it!

ray_aramburo's avatar
ray_aramburo
Icon for Super User rankSuper User
2 years ago

Go to the visual filters in the filter pane and look for the measure/values card (in this case Number of Milestones). Then filter it by "is not blank".

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for sharing, ray_aramburo. Unfortunately, I still cannot find it as I am very new to Power BI. Can you please advise me where I can find the appropriate setting from the view I have attached?

I did noticed that in the "visulisations" pane, the Y-axis which contains the "Count of Course Code" is what shows the bars and their totals on the charts.

 

Once again, thank you for your help thus far and for your continued support.

 

 

  • ray_aramburo's avatar
    ray_aramburo
    Icon for Super User rankSuper User
    2 years ago

    No problem! Open this pane:

    Then you can perform something like this:

     

    Keep in mind that you need to have the chart selected to have those cards there.