Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi All,
i need your input and guidance for below scanrio/
I have colum 2 visual.
1. Column chart, with Datemonth , with 2 measures. as
2. simpel table visual with name [column]
when i click the any one of measures values, i was expected it will filter the 2nd visual name list. however it only showing data filtered by Datemonth field.
is it possible to get calculated measure values from visual 1 , of its filtered data in 2 nd visual ?
the drill through not helping me, as i wanted in the same page and like to see the actual table rows/name[column] list of the measure is calculated agains.
Solved! Go to Solution.
Hi @Arons ,
Please drag the point field to the Y-axis of this clustered column chart than two measures.
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Any one has idea, how to get the measure data filter the table.
Thanks Denis, please find below visual and data used.
i have given details table, and i am trying to filter only the measure either false/true and see the below name list filtered accordingly, however this only filters on month level and shows data.
pls check and add your inputs. thanks
Adam | 100 | True | 1/1/2022 12:00:00 AM |
betty | 98 | False | 1/1/2022 12:00:00 AM |
Sam | 98 | True | 1/1/2022 12:00:00 AM |
Cindy | 102 | False | 2/1/2022 12:00:00 AM |
Daniel | 101 | True | 2/1/2022 12:00:00 AM |
Ricky | 101 | False | 2/1/2022 12:00:00 AM |
eva | 99 | False | 4/1/2022 12:00:00 AM |
Francis | 89 | True | 4/1/2022 12:00:00 AM |
ketty | 89 | True | 4/1/2022 12:00:00 AM |
nike | 89 | True | 4/1/2022 12:00:00 AM |
Hi @Arons ,
Please drag the point field to the Y-axis of this clustered column chart than two measures.
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Chenwuz,
my requirements is to have measures filters working. for example, i have given simple measure which has false or true, in real requirements, we would be having complex dax which shows values,
of corresponding values, if we wanted the underlying table rows, how to achive. like customer repeating with more thanx, with many conditions, i might have created couple measures for trend analysis,
to get actual details, put this requirements.
Hey @Arons ,
the behavior depends on the data model.
Can you create an example file? Then it's easier to help you.
Best regards
Denis
Thanks Denis, please find below visual and data used.
i have given details table, and i am trying to filter only the measure either false/true and see the below name list filtered accordingly, however this only filters on month level and shows data of name , points,,etc.
is it possible when i click within month, either false/measure value to get correponding result in below table. as it only shows month wise still,
pls check and add your inputs. thanks
Adam | 100 | True | 1/1/2022 12:00:00 AM |
betty | 98 | False | 1/1/2022 12:00:00 AM |
Sam | 98 | True | 1/1/2022 12:00:00 AM |
Cindy | 102 | False | 2/1/2022 12:00:00 AM |
Daniel | 101 | True | 2/1/2022 12:00:00 AM |
Ricky | 101 | False | 2/1/2022 12:00:00 AM |
eva | 99 | False | 4/1/2022 12:00:00 AM |
Francis | 89 | True | 4/1/2022 12:00:00 AM |
ketty | 89 | True | 4/1/2022 12:00:00 AM |
nike | 89 | True | 4/1/2022 12:00:00 AM |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
88 | |
82 | |
64 | |
49 |
User | Count |
---|---|
125 | |
111 | |
88 | |
69 | |
66 |