Displays filter data based on criteria and day of month

[Bambang_Sono]

I have two tables how do I display them in the view table according to filters a,b, and c, taking from the target table by day and month

[v-junyant-msft]

Hi @Bambang_Sono ,

Create a field parameter:

Then use the field parameter to create the table visual:

And the final output is as below:

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

[Bambang_Sono]

For example, using the Dax formula to measure parameters, or measuring the parameters.
this is my example table

[v-junyant-msft · Accepted solution]

Hi @Bambang_Sono ,

Sorry, but the expected results in your two screenshots are completely different. I am beginning to not understand what effect you want to achieve:

In addition, I also cannot understand why you display these 10 rows of data? Can you explain in detail what is the logic of which type of value is displayed for each date?

I can help you convert your original data into this format:

Please select the DATE column in Power Query, and then select Unpivot Other Columns:

Then "Close & Apply":

Next, how do you filter the data you want to view? Please explain your logic more clearly, thank you!

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

[wini_R]

Hey @Bambang_Sono,

The question is not very clear, can you please provide more context on your challenge and what exactly you want to achieve?

[Bambang_Sono]

sorry, I have two tables how do I display them in the display table according to filters a,b, and c, taking from the target table