The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello all,
Its my first time wrinting in this forum.
I would like to delete all the lines that have a negative number in my column "IdComm".
I dont want to filter greater than 0, because is only a filter. I really want to delete them of my table.
Thanks in advance for helping me,
Solved! Go to Solution.
Hi @TatianaGuihur ,
Set the filter with Power Query. (Transform data)
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
In data transformation or edit query under Data View. Go and filter you data.
Refer :https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
If you want to really delete records from your table, you may have to delete them in your datasource.
You could use Power Query to delete them, but they would only be deleted from the data you loaded into power bi.
I'm a personal Power Bi Trainer I learn something every time I answer a question
|
Help when you know. Ask when you don't!
yes, I only want to delete them in my power bi report. Not in the BD source.
How can I do that?
Hi @TatianaGuihur ,
Set the filter with Power Query. (Transform data)
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Thank you so much for helping you three people. I did what @mwegener said. Is working now. I understand better.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
76 | |
65 | |
52 | |
51 |
User | Count |
---|---|
128 | |
117 | |
78 | |
65 | |
63 |