Forum Discussion
Using measure on Pie Chart Value, it cannot filter the table
Hi,
Hoping the experts can help me with the pie chart issue below.
In the dashboard, the score weighting and scale are set by parameters.
Score = height * height parameter value + weight * weight parameter value
, which (height parameter value + weight parameter value) = 1
Grade scale = if Score > A grade parameter value, A
if Score <= A grade parameter value and >C grade parameter value, B,
C
Now, I created a pie chart by 3 measure by counting A, B, C grade separately , since I cannot add the grade measure to the pie chart value.
However, this pie chart is not able to filter the table.
How to make relationship between the pie chart and table in this case? I expect when I select "A" in the pie, the table show only "A" result.
Thank you for your time.
2 Replies
- ThejeswarSuper User
Hi BobChris,
If the Columns Score and Grade are direct columns, then this functionality of filtering the table based on pie chart selections will work automatically with out doing anything special.
But since you say that the columns are based on parameter values, I am not sure how it behaves.
If you can a share a PBI file with sample data and this scenario in it, we might be able help better!!