The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
Here is my data source excel, https://1drv.ms/x/s!AsM9bO8zGUN6qnXhW_xy3NskH3jT
and my pbix file, https://1drv.ms/u/s!AsM9bO8zGUN6qncapG3qHuDHI0ce
I create two measures, Outgoing and InComing. and show the stacked columns chart with these two measures.
I aslo create a table to display source data on the same page.
I want to show the data in the table according to the chart, that is to say, I click somewhere on the chart, the table only show the related data. Do you have any suggestion?
I also upload the snapshot what I created.
Solved! Go to Solution.
Hi @hemingt ,
We can update the meausre to get the result as below.
Measure = VAR _sele = SELECTEDVALUE ( Sheet1[Week] ) RETURN IF ( MAX ( Sheet2[Create_Week] ) = _sele || MAX ( Sheet2[Close_Week] ) = _sele, 1, 0 )
what's more, if I click the red part of week 1908 column, right table should only display the Create_Week = 1908.
For the request, we cannot achieve that here.
Regards,
Frank
Hi @hemingt ,
Create a measure as below and make the table visual filtered by the measure.
Measure = VAR _sele = SELECTEDVALUE ( Sheet1[Week] ) RETURN IF ( MAX ( Sheet2[Create_Week] ) <= _sele && MAX ( Sheet2[Close_Week] ) >= _sele, 1, 0 )
Regards,
Frank
Hi @v-frfei-msft ,
Thank you very much for your help.
it seems the solution did not work.
Please see your uploaded snapshot.
you click the week 1908 column, in the right table, those issues which Close_Week or Create_Week not equal 1908 displayed.
it should only display the Close_Week =1908 or Create_Week =1908.
what's more, if I click the red part of week 1908 column, right table should only display the Create_Week = 1908.
Hi @hemingt ,
We can update the meausre to get the result as below.
Measure = VAR _sele = SELECTEDVALUE ( Sheet1[Week] ) RETURN IF ( MAX ( Sheet2[Create_Week] ) = _sele || MAX ( Sheet2[Close_Week] ) = _sele, 1, 0 )
what's more, if I click the red part of week 1908 column, right table should only display the Create_Week = 1908.
For the request, we cannot achieve that here.
Regards,
Frank
Hello
You mean that you dont want the table be updated when you click in some column?
Hi @aoliver ,
I want to the table refresh the data according to the click on the chart,
such as,
if I click on the Outgoing on the Week 1902, then only issues of Close_Week = 1902 displayed in the table,
if I click on the InComing on the Week 1902, then only issues of Create_Week = 1902 displayed in the table.
Anyone who can give some advice? thank you!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |