Forum Discussion
Can I create a single visualization with a double y axis without it grouping my dataset?
I have 2 Excel spreadsheets. The 1st spreadsheet contains the compliance rate for burgers ate, but isn't just a simple compliance / eligibility formula, so that's why it's in a separate sheet. The ...
Hi CoreyLearnsBI,
Perhaps you can try to extract the axis field as a unconnected table as use it as axis of the chart, then you can write measure formulas to look up and calculated values based on current axis values from different tables.
Regards,
Xiaoxin Sheng
Measure formulas within Excel or Power BI? And would this eliminate my grouping issue?
Why is gouping a bad thing in this case? What is the story you are planning to tell?
Grouping is bad because I'm dealing with medical providers and trying to show how many non-compliant members there are for each particular "type of burger" instead of it all grouping to 24 on the y axis.
