This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hi All,
In one visual we need to display one day data and other visual we need to display all dates data. If we click on first visual values, in 2nd visual need to display all dates data for selected value in 1st visual.
issue:
it is displaying only one day data in 2nd visual.
Thanks in advance.
@Anonymous
Assume you have date D1 in your table and joined with Date D2 in date dimension. Make sure you create Visual 1 Date of the filter a give a visual level filter on the date from the table.
In the Second visual Take the Date from dimension and Try. If require use take measure with All on date
Measure Two = Calculate([Measure], All(Date[d2]))
HI Amit thanks for your reply but we don't have date dimension in our report
Hi @Anonymous ,
It seems you want to filter the data in Visual 2 by the selected date value on Visual 1... Could you please provide some sample data and screen shot for your expected result? The date on visual 1 and visual 2 are from same field?
Best Regards
Rena
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 26 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 65 | |
| 41 | |
| 28 | |
| 22 | |
| 22 |