Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hey there.
I have a Sales table that goes like this:
Sales:
Id | IsTest | IsPaid |
1 | TRUE | FALSE |
2 | TRUE | TRUE |
3 | FALSE | TRUE |
A Brands table:
Brands:
BrandId | BrandName |
1 | Toyota |
2 | Honda |
And lastly a Sales_Brands table:
SaleId | BrandId |
1 | 1 |
2 | 1 |
3 | 2 |
Both Sales and Brands have relationships with Sales_Brands.
I have a Pie Chart report on Brands that uses "BrandName" as a legend and "BrandId" as Values. When I add a Page Filter using the "IsTest" column from Sales, my report updates itself normally.
When I add another Page Filter, this time using the "IsPaid" column from Sales, my Pie Chart only works with the FALSE value. If I select the TRUE value, my Pie Chart gets zero data.
The filter even correctly counts its corresponding values:
I tried changing the Column type from Boolean to Whole Numbers and the behavior is still the same. Does anyone have any idea of why this is happening?
Solved! Go to Solution.
Hi @v-qiuyu-msft!
Thank you very much for your reply.
In the time that I've waited for it, I ended up discovering what the problem was. My SalesBrand table had its relationships set wrong. (I am noob in Power Bi yet and didn't know that Power Bi created its own relationships when we imported our data set to it)
What solved it was that I made the relationship between SalesBrand and Sales into a two-direction relationship instead of a single one (was from SalesBrand to Sales).
I can't fairly explain why this was happening but I can certainly tell that once I modified the relationship, everything started behaving like expected.
Hi @William_Ylab,
From your description, it seems you set two page level filters, one is "IsTest" column from Sales, the other is "IsPaid" column from Sales, right?
Those two page level filters are AND condition. Assume you select False for IsTest and True for IsPaid, corresponding ID in Brand is 3, while there is no BrandId 3 in Brands table. Then the Pie chart display blank.
In your scenario, please check if the selected values for "IsTest" and "IsPaid" has corresponding BrandId in Brands. If you are not sure, you can share the pbix file with those three tables with us.
Best Regards,
Qiuyun Yu
Hi @v-qiuyu-msft!
Thank you very much for your reply.
In the time that I've waited for it, I ended up discovering what the problem was. My SalesBrand table had its relationships set wrong. (I am noob in Power Bi yet and didn't know that Power Bi created its own relationships when we imported our data set to it)
What solved it was that I made the relationship between SalesBrand and Sales into a two-direction relationship instead of a single one (was from SalesBrand to Sales).
I can't fairly explain why this was happening but I can certainly tell that once I modified the relationship, everything started behaving like expected.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
76 | |
61 | |
37 | |
33 |
User | Count |
---|---|
99 | |
56 | |
50 | |
42 | |
40 |