Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Continued Contributor
3 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.