Forum Discussion
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 the image attached. I would like to limit the display to contain only the months with values. All empty months should be hidden from view.
Can this be achieved in Power BI? If so, can you guide me how to do that?
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.
Apply that same filter in the Count of Course Code card, not in the Month card. That should do it!
6 Replies
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".
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.
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.
Thanks again, ray_aramburo. That was most helpful. I found and applied the filter as you have shown.
However, for some reason, the empty months are still displaying on the graph. I am assuming it is related to the calculations or settings applied to the card. I will see whether I can find additional information to help me further :).
The image attached is what I have tried. I did this using And / Or. I also tried it with "is not empty" and "is not blank" but neither have updated the visual so far. I will check the settings and other features.
Apply that same filter in the Count of Course Code card, not in the Month card. That should do it!
Awesome! Thanks a lot, ray_aramburo. That worked like a charm :D. The chart is looking much nicer now.