Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi
How do I achive below format of a visual in Power BI? Matrix visual with "switch Values to Row" is not as expected.
Dim Date : Date, Year, Month
Fact Sales : Sales, YTD %, WTD %, PTD % are Dax meanusure comparing to Last year. All % Dax are using Calculate as period is 5-4-4.
sample Fact Data
Date | Sales | Traffic | |
1/1/2023 | 100 | 5000 | |
1/2/2023 | 200 | 5500 | |
1/1/2022 | 50 | 4000 | |
1/2/2022 | 60 | 4500 |
Expected Format in Power BI Visual
Sales | Sales Vs Forecast | Traffic | |
Day | 0.2% | 0.1% | 2.1% |
WTD | 1.1% | 0.2% | 2.3% |
PTD | 2.1% | 0.3% | 2.4% |
YTD | 4.5% | 0.4% | 2.5% |
Format,Visual,Dax,Sales,YTD,alternative,Matrix,Table,Power,BI
This seems to be a simple request. Could you please give an Idea, anything will help? Thanks!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
6 | |
1 | |
1 | |
1 | |
1 |