Forum Discussion
Matrix table visual into donut chart
Hi everyone, I am having the a matrix table visual and trying to make it into a donut chart.
On the matrix table visual, I am having three rows with five different dax measures and a filter visual on.
Now, I am trying to change it into donut chart and show it only the sum amount, with the filter visual on, however, the filter on the visual doesn't seem to work. Is there any workaround on that? Thanks in advance.
1. Matrix table visual
2. Donut chart ---just copied the matrix table visual and convert it to donut chart---the amount is different from the total in matrix visual..possibly because I removed legends?
3. this is the filter on the visual
4. these are the rows and measures on the matrix table visual
Hi ronaldbalza2023 ,
According to your problem, you put five value fields, three grouped fields in the matrix, and after trying to change the matrix directly to a pie chart, you find that your visual filter doesn't filter this pie chart, right?
If it is convenient, I have the following possible analysis of your current problem, please review and troubleshoot:
1. The first thing you need to confirm is whether the fields you put in the visual filter are from the same table as the value fields in the pie chart? If they come from the same table, is there a well-oriented filtering relationship between them?
2. Your filter field is "WTP Total", and the filter condition set is greater than or equal to one value, if it is convenient, you can first go to the Data view to see what kind of value display is under the current filter conditions?
3. As far as I know, if you put measures in these value fields in the pie chart, the measure needs to check if the All() function is not used to define the context of the output value, because according to the definition of the All() function, it will force the current measure to remove any filtering context
If there are no problems with all checks, you can provide your .pbix file (which does not contain sensitive data) that can be reproduced for further analysis. Thank you so much!
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi ronaldbalza2023 ,
According to your problem, you put five value fields, three grouped fields in the matrix, and after trying to change the matrix directly to a pie chart, you find that your visual filter doesn't filter this pie chart, right?
If it is convenient, I have the following possible analysis of your current problem, please review and troubleshoot:
1. The first thing you need to confirm is whether the fields you put in the visual filter are from the same table as the value fields in the pie chart? If they come from the same table, is there a well-oriented filtering relationship between them?
2. Your filter field is "WTP Total", and the filter condition set is greater than or equal to one value, if it is convenient, you can first go to the Data view to see what kind of value display is under the current filter conditions?
3. As far as I know, if you put measures in these value fields in the pie chart, the measure needs to check if the All() function is not used to define the context of the output value, because according to the definition of the All() function, it will force the current measure to remove any filtering context
If there are no problems with all checks, you can provide your .pbix file (which does not contain sensitive data) that can be reproduced for further analysis. Thank you so much!
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.