Forum Discussion

krrish116's avatar
krrish116
Resolver II
5 years ago
Solved

Only Table Values will Show Current Month Data..

Hi amitchandak , I had a table and based Customer           Date                   Value      Product XXXX             20-02-2020              76          ABC YYYY              12-03-2020        ...
Need Help
Show and Tell
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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.

  • amitchandak's avatar
    amitchandak
    5 years ago

    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's avatar
krrish116
Resolver II
5 years ago

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..

amitchandak's avatar
amitchandak
Super User
5 years ago

krrish116 , One option is close interactions between the first visual(where you want all the months) and allow it to interact with the second.