Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Pbiuserr
Post Prodigy
Post Prodigy

Modeling approach for that chart

Hello,
I am going to create chart which would be like down below, there is a model schema and explaination what I would like to achieve. How to model such chart? Copy referential tables once again, create inactive relationship and play with it in a calculate ( sum(facttable[isactiveflg], userelationship()) ?

 

Pbiuserr_0-1658999069871.png

 

4 REPLIES 4
SpartaBI
Community Champion
Community Champion

@Pbiuserrhey, we can do a quick zoom if you want in couple of hours.

Hey! I think I have done it on my own (its my feature that If I ask for help then my brain starts to work more efficient 😄 ). Can we agree that if no one make comments to that, we'll skip the meeting, but if they come back and say its done incorrectly, then we'll have a meeting (in a few days I guess) ?

@Pbiuserr deal!

Okay. I would be grateful

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.