Forum Discussion
Need help with power BI
My actual BI dashboard connected from SQL server. In my dashboard table, as per maximum run time showing related BulkProduction value, DyelotNo, Date. Some BultProduction value become 0, when dyelot value combined with 1A, SP, RP.
Here I need to hide or remove all related columns which dyelot no combied with 1A, SP, RP. It's need only for table.
In my attached excel file green color columns production value is 0 and Dyelot no combined with 1A, SP, RP. It's required to those columns hide or remove in attached BI table.
https://drive.google.com/file/d/1sUHiUuwxIexsHrDfJQX1dBFUvyBkJ6aA/view?usp=sharing
I'm always ready, if need any query.
Hi @Emranit ,
Thanks for connecting with the Microsoft Fabric Community Forum.
I’ve investigated the issue you raised and was able to replicate the problem using the data you shared.
- In Power BI, go to Home and click on Transform Data to open the Power Query editor.
- Once you're in the editor, find the Bulk Production column.
- Click the filter icon on the Bulk Production column, then choose Number Filters > Does not equal.
- Type 0 to exclude rows where the Bulk Production is 0.
- In the same manner
- Click the filter dropdown on the DyelotNo column.
- Choose Text Filters > Does not equal (or use Does not contain if DyelotNo has other values with 1A, SP, or RP as part of the text).
- After setting the filters, click Close & Apply in the Power Query editor to load the filtered data into Power BI.
- This method removes the rows from the entire dataset, so they won't even be available in your visualizations.
Please mark "Accept Solution" if this post helped you, so it can assist other members more effectively.
2 Replies
Hi @Emranit ,
Thanks for connecting with the Microsoft Fabric Community Forum.
I’ve investigated the issue you raised and was able to replicate the problem using the data you shared.
- In Power BI, go to Home and click on Transform Data to open the Power Query editor.
- Once you're in the editor, find the Bulk Production column.
- Click the filter icon on the Bulk Production column, then choose Number Filters > Does not equal.
- Type 0 to exclude rows where the Bulk Production is 0.
- In the same manner
- Click the filter dropdown on the DyelotNo column.
- Choose Text Filters > Does not equal (or use Does not contain if DyelotNo has other values with 1A, SP, or RP as part of the text).
- After setting the filters, click Close & Apply in the Power Query editor to load the filtered data into Power BI.
- This method removes the rows from the entire dataset, so they won't even be available in your visualizations.
Please mark "Accept Solution" if this post helped you, so it can assist other members more effectively.
Thanks for your solution. In my actual dashboard, Bulk_Production is not a RAW data(SQL imported data). Bulk_Production column created by a DAX for 0 value. So, Bulk_Production column is not showing in power query editor. My RAW data imported from SQL server.
My Bulk_Production column already created depends on Dyelot no combination. Bulk_Production is showing 0 value when get 1A, SP, PR, RP etc in Dyelot No. Please give me the solution from my present status.
Thanks for understanding.
