Measure on X-Axis

[AV]

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

[Greg_Deckler]

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...

You probably won't be able to do that though if you have a Live connection.