Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi everyone!
I have a doubt. Can I apply business rules to a data set in PowerBI?
Example: In my data set I have a fact/sales table and the master tables for each dimension (Product, Company, Brand, etc.) I wish to have a data set with all the sales, and modify it with some business rules. A business rule would be to eliminate all the sales of Brand XX from Company XXX. A other rule could be, the sales of Product ZZZ from Company GGG must be moved to Company HHH.
How can I perform this in PowerBI?
Thanks in advance?
Hi @Anonymous,
Based on my understand, I don't think it will be easy to achieve this in Power BI. You'd better to do it on your data source. You can cleaning your data before loading into data warehouse. And then use this data warehousr as the data source of your Power BI report.
Regards,
Charlie Liao
Thanks @v-caliao-msft for your reply.
Yes, doing it in the DataWareHouse whas one of my options. In fact, many business rules are solved there. The problem is that some rules are only for visualization in a specific scenario. Example, when having a monthly meeting for showing the months sales.
Thanks!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |