When using direct query you should be able to change a date axis to show only the month. This works using excel or when doing a transform but neither of these are possible using DirectQuery. Even wor...
CRUCIAL TO HAVE THIS FEATURE ON !!! POWER BI IS MOVING TO STREAMING LIVE DATA WHERE DIRECT QUERY IS THE BASE FOUNDATION OF THAT PRINCIPLE. GET LIVE AND UPDATED DATA AS SOON AS YOUR DATABASE CHANGES. SO HAVING THIS KIND OF LIMITATION ON A BASIC FEATURE IT'S A ANNOYING.
