Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. 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] ) ) )
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.