Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
I'm new (very new) to PBI, and simply taking a value by product and dividing out to get a percentage.
I'd like to graph percentages over time, but when I click on the respective line chart icon, it displays incorrect percentages.
It almost appears as though it's converting it to % of row, not column as I had displayed in the data.
How can I correct? See the screen shot with the correct data to the left, however the incorrect line chart displayed on the right.
@MSojo , BAsed on what I got , Assume you are using measure M1 in Matrix
% Measure used in Matrix
divide([M1], calculate([M1], removefilters(Table[common_drug_name] ) ) )