Forum Discussion

Bal_Singh's avatar
Bal_Singh
Icon for Helper I rankHelper I
1 year ago

Is it possible to create a Bar Chart based on a filtered Table Visual?

I have a table visual which is filtered on a measure having values greater than zero. How could I use the filtered results to create a bar chart? Not sure if that is even possible but would be inter...
Need Help
Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
1 year ago

Bal_Singh 

In Power BI, you cannot directly "reuse" a filtered table visual’s results for another visual. However, you can recreate the same filtering logic using DAX to achieve the same results for your bar chart.

If you want to explicitly "capture" the filtered results, you can create a calculated table to hold the data where your measure is greater than zero. Then use this calculated table for your bar chart.

FilteredTable = 
FILTER(
'Sales',
[Revenue] > 0
)

Now, build the bar chart using fields from FilteredTable.

 

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

Bal_Singh's avatar
Bal_Singh
Icon for Helper I rankHelper I
1 year ago

Thank you Kedar_Pande ,
I thought of this too but the issue here is that underlying data is also dynamically caluclated measures and not a Table as such. I'll be uploading the pbix soon with masked data (Not sure if this would be possible due to limitations). Hopefully that will help. Thanks.

  • Kedar_Pande's avatar
    Kedar_Pande
    Icon for Super User rankSuper User
    1 year ago

    Please share a simplified version of your PBIX file (in English) without sensitive data. You can upload it to a public cloud service like OneDrive, Google Drive, or Dropbox and share the link. This will help in understanding your data structure and the issue, allowing for more precise guidance.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Bal_Singh ,

     

    I think you issue should be caused by using "100% Stacked bar chart". I suggest you to try "Stacked bar chart".

    If this reply still couldn't help you solve your issue, please share a easy sample with us and show us the result you want.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Bal_Singh's avatar
      Bal_Singh
      Icon for Helper I rankHelper I
      1 year ago

      Hi Anonymous ,
      Thank you, your method is quite clear for a simple model.
      I tried your method to my model but it did not work for me unfortunately.
      Possible reason being my model is bit more complex in the way measures are being calculated.
      I would like to upload my masked model but unable to do so in this portal and I can't upload it to any personal cloud due to limitations. Any suggestion would be great. Thank you! Bal.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Bal_Singh ,

         

        I think you can show us more detilas about your table and the data model like relationships/measures and so on.

        You can create a easy sample file or data source to us and give us the measure you are using.
        We need to reproduce the issue.

         

        Best Regards,
        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.