Forum Discussion
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 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..
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.
6 Replies
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.
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..
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.
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.
