Forum Discussion
AV
8 years agoNew Member
Measure on X-Axis
Hi All, Hope you're doing well. I am pretty new to Power BI. I am using SQL server as a source using direct query. I need to show "Product sub-category per product" vs "# of Product" in the below...
Greg_Deckler
Community Champion
8 years agoIn general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
You probably won't be able to do that though if you have a Live connection.