Power BI: How to pivot column without nulls added?
I want to pivot a column but Power BI adds nulls. I selected the column 'Question' and selected 'pivot column' then selected 'Response' with no aggregation but Power BI added nulls. Is there a way to prevent this? I spent the whole day on this and I am sure there this a simple solution. Thanks for your help in advance.
Solution
If you drop/remove the Category column before the Pivot then you can avoid the nulls since all the other columns have the same value for each pair.
- Summarise by multiple columns dax
- PowerBI: How to "transpose" matrix visualization?
- Power BI - drill down on line chart
- Can I use Power BI to report on how long Azure DevOps work items spend in each state?
- Conditional transforms in Vega
- DAX measure for dynamical calculation of value based on previous date
- How to get the list of all reports/datasets that plug to a dataset or dataflow (across workspaces)?
- Integrating PowerBI Measures into Deneb Vega Visualisation (David Deneb Sankey)
- Powerbi Why does measure produce different result based on equivalent filters
- Convert timestamp to date in DAX with DirectQuery
- Panning the second brush with the first brush in Vega
- DAX script for measure based on date dimention
- Scale clustered chart to use up space in visual - Power BI
- Calculating percentage change over month in Power BI
- Show null values as a gap in vega line charts
- Setting minimum x axis unit to a day
- Snap Brush Interval to Weekly Period
- Adding an IF statement to a Measure
- Adding Fields in an existing Parameter PBI
- Assistance Needed with DAX Measure for Calculating Sequential Distance in Power BI
- Can Publish Power Bi Report Server to Power Bi Service?
- The PeriodCustomer column is not found or cannot be used in this expression. Power BI (DAX)
- DAX measure or calculated column for dynamical calculation of value based on date and ID
- Joining consecutive values in rule mark
- How to handle multiple dimension records having the same name even though they have unique key/relation with the fact table (1:M)?
- Find and isolate the values found in a text column - DAX
- Setting conditional colors per task age
- Displaying latest date until a new data upload happens
- DAX Query Issue: Calculating Current Value using Previous Row's Calculated Value
- Power BI Embedded - .net 6