Change Slice and then change Querie

[amfc]

Hi Team,

I have data separated by month on Power Bi queries.. How can i fix the problem, on the slicer when i press January he will read the data querie of january, when i press Febraury, he will get tje data from February and so on... 

Thank you

[Syndicate_Admin]

if Date.IsInCurrentMonth( [Date] )

Like this
then "Current Month"
else [Month]

  set the slicer to "Current Month", when the month changes and the dataset will get refreshed & slicer's "Current Month" selection can remain the same. What "Current Month" get changed after it and you will find the proper outputs

[amfc]

Hi, 

Where is write this code?

Thank you

if Date.IsInCurrentMonth( [Date] )

Like this
then "Current Month"
else [Month]

[amfc]

Hi xzmiche, Yes, but when i press January i need to see only January values, and when i press on February i need to see only february values... 

[xzmiche · Accepted solution]

OK. I see you have tables by month name and you want filter by month for your graph. The best practice is to comine all your month based tables and then pick fields in combined table:

1. Go to Power Query

2. Append Query as New

3. You will get combined table. Close Power Query

4. Pull the fields in Combined table to your graph and slicer

[amfc]

Thank you xzmiche. It works...

[xzmiche]

It's true when you pick month field in your table as slicer field to filter other visuals. When you do not select any month, your visuals will show all data and when you select one, the visuals will only show the month your selected.