Forum Discussion
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 format. I have created a table with values which "# of product" can have, but the problem is coming while connecting the clculated table values to
Thanks,
Abhi
1 Reply
- Greg_Deckler
Community Champion
In 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.
