Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi Guys,
I have a matrix that displays all my data, execpt I have been asked to put the dates across the page and the data down the page (the transpose of the matrix in the image).
I have tried moving "Date" to Columns field and Values to the "Rows" field but the software won't let me.
Is there a way for me to get dates across the page and the rest of the data going down the page?
Thanks
Solved! Go to Solution.
You need to change the Dates field by moving it from the rows bucket to the columns bucket (leave the rows bucket empty):
Next search for "Switch" in the formatting pane and turn on the "Switch values to rows" under Values ->options
Proud to be a Super User!
Paul on Linkedin.
You need to change the Dates field by moving it from the rows bucket to the columns bucket (leave the rows bucket empty):
Next search for "Switch" in the formatting pane and turn on the "Switch values to rows" under Values ->options
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
82 | |
79 | |
68 | |
46 | |
46 |
User | Count |
---|---|
105 | |
44 | |
39 | |
39 | |
39 |