The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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] ) ) )