Forum Discussion
Power BI Table
I have 2 columns in table against the site. One column (RiskHeader) used as column in power bi table and another RiskLevel column used in values with first RiskLevel. I want to add slicer with RiskLevel and filter only one element from Risk Header with the one I choose in slicer and should filter the site with the respective element for sites
5 Replies
PRAVINV Add a table visual to your Power BI report.
Drag the Site and RiskHeader columns to the table visual.Add a slicer visual to your report.
Drag the RiskLevel column to the slicer.You need to create a measure that will help filter the RiskHeader based on the selected RiskLevel
DAX
SelectedRiskHeader =
VAR SelectedRiskLevel = SELECTEDVALUE('YourTable'[RiskLevel])
RETURN
CALCULATE(
FIRSTNONBLANK('YourTable'[RiskHeader], 1),
'YourTable'[RiskLevel] = SelectedRiskLevel
)Use the measure SelectedRiskHeader in your table visual to filter the RiskHeader column. You can do this by adding a visual-level filter to the table visual and setting it to show only the value of SelectedRiskHeader.
Ensure that the relationships between your tables are correctly set up so that filtering by RiskHeader will also filter the Site column accordingly.
Hi PRAVINV ,
Did the reply offered help you solve the problem, if it helps, you can consider to accept it as a solution so that more user can refer to, or if you have other problems, you can offer some information so that can provide more suggestion for you.
Best regards,
Lucy Chen
Hi PRAVINV ,
we wanted to check in as we haven't heard back from you. Did our solution work for you? If you need any more help, please don't hesitate to ask. Your feedback is very important to us. We hope to hear from you soon.
Hi PRAVINV ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi PRAVINV ,
we wanted to check in as we haven't heard back from you. Did our solution work for you? If you need any more help, please don't hesitate to ask. Your feedback is very important to us. We hope to hear from you soon.
