Forum Discussion
Powerbi
- 2 years ago
Hi Millar
You can create a flag measure that checks if some value of the graph is selected.
For example, if my graph rankin some measure by-products that will look like this:Now you can use this test measure to filter a table : (note that you have to have different columns at the graph and table)
To make the user's life easier, you can use conditional formatting on the title that will guide him to make a selection from the graph if the table is blank.
You can create a measure for the title of the table like :and to use conditional formatting by value to put it :
and to make it red use conditional formatting of the title color
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thanks but I want it for stacked bar chart x axis has month-year(like 12-2023) y axis has count of(sales id) if user clicks bar then in another chart it show sales id details (like row wise 1,2,3)
Please share a link to pbix with example + show the desired result