Only Table Values will Show Current Month Data..

[krrish116]

Hi @amitchandak ,

I had a table and based

Customer           Date                   Value      Product

XXXX             20-02-2020              76          ABC

YYYY              12-03-2020             45           CVD

AAAA            20-03-2021             85             ABC

BBBB              02-04-2021            96               CVD

CCCC             03-04-2021            67               CVC

On Basis of Date i have Created Month-Year Column and im showing 3 slicers in report

Customer, Month-Year, Product Slicers Resp.

Based on the above table im showing 2 visuals one Visual is graph

Which contains Sum of Value on Column Values , Customer on Column Series , Month-Year on Shared Axis .

2nd Visual is Table

Which it will show all the above Table Data.

Now the Problem is in the 2nd visual(Table) by default i have to show only Current Month Data.

1st visual will show all Month-Year Data.

Please help me to sort out this.

Thanks,

Krish..

[Jihwan_Kim · Accepted solution]

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.

[Anonymous]

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.

[Jihwan_Kim · Accepted solution]

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]

Hi @Jihwan_Kim ,

Thanks for the Quick Response..

The Problem is by default it will show Current Month and if i select some month-year then both the visuals has to change.

Thanks,

Krish..

[amitchandak]

@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

[krrish116]

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 · Accepted solution]

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