Forum Discussion
Post PatronHow hide a graph if selected month no data , and display data over multiple if the month has data
Cobra77
My suggestion is use month number instead month text, and for the measures you can use if to set the condition, something like:
If(selectedvalue([month number])< 9, [Sales sum allcalendar], [Test_data])
Share your test pbix if not clear.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Post Patronhi Anonymous
We cant use month month number in the slicer.
in the real application these are periods, example "from March 1 to March 20".
and it is necessary to test first if there are values on the selected period.
and everything must be dynamic of course.
I share with you the test pbix for this scenario :
https://1drv.ms/u/s!AmluE3Tt6h4WgjSPAvhPJ5kOIhXm?e=q5o9nw
Thanks