How to pivot/unpivot data for a visual in Power BI without using Power Query
I have a visual that I need to display in a certain way, where I think Unpivot would be the solution in Power Query. However the data set its coming from is our 'main' data set and I can't pivot/unpivot there as it would affect many other visuals.
The visual currently displays as:
I am trying to get it to display as:
Is there any functionality within DAX that can do something similar?
Solution
Use the Matrix visual, add the date to the Columns well, and add Plan and Actual to the Values well. Then in the visual options go to Values > Options and enable the Switch values to rows option.
- How to pivot/unpivot data for a visual in Power BI without using Power Query
- PowerBi data refresh from the source using a set value
- DAX Query/Expression syntax question ":="
- Data Flow Gen1 with Dynamic Data Source/Pagination
- Power BI multi language report, adding language to url is not working
- power bi donut and slicer
- Sum Values Which Appear In Both Tables
- Why is this small query in Power BI using several gigabytes of memory?
- How to dynamically provide colour hex codes (from a dataset) to Deneb (Power BI) Visualizations Using Vega/Vega-Lite?
- Azure Maps Forward Geocoding and Route Matrix API - billing and cost perspective
- How to pass parameters in embedded Power BI paginated report?
- Power BI import PBIX file with quarkus-rest-client
- Create new Power BI report embedded in Angular application
- Hot to get subtotal only for one column in Power BI Matrix
- How to create slicer from column name
- Error at accessing Azure Maps Geographic API Endpoints from Web query in PowerBI
- ALL() function returns only non repeated values in PowerBI formula
- Forecasting Multiple Linear Regression Trends on Same Time Series Data Visualization
- Power Bi Conditional column on table row[0]
- Deneb (Vega-lite) - Access Other Columns in Axis Label Expression
- Could not grant admin consent. Your organization does not have a subscription (or service principal) for the following API(s): Power BI Service
- Add aggregated column into the same table
- PowerBI: RDL -> PBIX conversion // is it possible?
- How to render Power BI slicer items with Python Selenium
- PowerBI doesn't Refresh
- Custom sort table affecting the measure values
- Eliminate forecast for past dates
- SQL-IN like query in Power BI DAX
- Power BI Running Total, Data Missing/Unwanted Data for non-date related time line
- How attach actuals and forecast in a Line Chart