Forum Discussion
Only Table Values will Show Current Month Data..
Hi, krrish116
Please correct me if I wrongly understand your question.
I created a sample pbix file, and if I connected all tables, then the table visualization would show only the current month. However, chart visualization also would show the current month only. So, I edit interaction between date-slicer and chart visual as NONE
Please check the below picture and sample pbix file if it is what you are looking for.
https://www.dropbox.com/s/n0ebhn3d80rb3r0/krrish.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
krrish116 , One option is close interactions between the first visual(where you want all the months) and allow it to interact with the second.
krrish116 , On of the way is that in the visual level filter, choose the date and use relative date filter and use this month.
Or you have to use the default of month slicer using this month and interact only with one of the visual
Default Month : https://www.youtube.com/watch?v=hfn05preQYA
Ineractions : https://www.youtube.com/watch?v=GIfRKzhMaR4
Hi amitchandak ,
The problem is if i do the above then if they select any other month-year then the data is not coming.
By default it has to show current month data in table and all in Graph, and if i select any other month-year slicer then both the visuals has to change.
Please help me in sorting out this.
Thanks,
Krish..
krrish116 , One option is close interactions between the first visual(where you want all the months) and allow it to interact with the second.
