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. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi krrish116 ,

 

Based on your description, you can do some steps as follows.

1. Create a calculated table.

Table = SUMMARIZE('Sheet3',Sheet3[Month-Year])
2. Create a relationship between two tables.

3. Create a measure and drag it to the filter on the table visual. (equals to 1)

Measure = 

var x1=SELECTEDVALUE('Table'[Month-Year])

return

IF(ISBLANK(x1),IF(MONTH(MAX('Sheet3'[Date]))=MONTH(TODAY()),1,0),IF(MAX('Sheet3'[Month-Year])=x1,1,0))
4. Replace the slicer of 'Your original table'[Month-Year] to the slicer of 'Table'[Month-Year].

Result:

 

Hope that's what you were looking for.

Best Regards,

Yuna

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.