Forum Discussion
Need help on designing Visual.
Hi Anonymous
To my knowledge, I don't think you can select a different color for region 2 unfortunately. Here is a example of what you can do:
I can share the PBI file if this is what you need.
Hi Anonymous,
By my tests, I'm afraid that it may impossible for us to set the column headers by condition for matrix in Power BI currently.
You could submit your idea in Power BI ideas Forum.
Best Regards,
Cherry
Thank you for sharing the PBI file.
Hi,
I have explored and Found solution to display the blank rows in the Matrix visual ( i.e. display the rows which has no values)
Refer the below post i submitted for more details (https://community.powerbi.com/t5/Desktop/Need-help-on-designing-Visual/m-p/561243#M264742)
Solution:
Rows --> select the Row field and right click and choose "Show items with no data" option.
Same applies to,
Columns --> select the Column field and right click and choose "Show items with no data" option.
Refer the below working visual:
Item5 has blank values but still the entire Item5 Row is displayed in the Matrix visual.
Hi Anonymous
To my knowledge, I don't think you can select a different color for region 2 unfortunately. Here is a example of what you can do:
I can share the PBI file if this is what you need.
Hi Anonymous Thank you for the solution. Appreciate it. Please share the PBI file.
1. Say if i know that i will have two Regions (i.e. Region 1 and Region 2) always then can i use the Region labels and hardcode the customcolor for Regions. correct me if i am wrong.Ex: Attached the powerbi desktop visual for reference
2. can we display Item3 row as blank even though there are no values pertaining to Item3 in the ItemVolumeByRegion Table Data.3. is it possible to remove the backgroundcolor for all Locations
4. Region and Item Header text and backgroundcolor is not required. is it possible to remove it. Attached the screenshot below.
Hi Anonymous,
By my tests, I'm afraid that it may impossible for us to set the column headers by condition for matrix in Power BI currently.
You could submit your idea in Power BI ideas Forum.
Best Regards,
Cherry
Hi Anonymous
can you please share the PBI file for the below example you shared initially in your first post.
Thanks.
Thank you for sharing the PBI file.
Hi Anonymous,
If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi v-piga-msft,
Part of my problem is solved with the shared sample PBI file (i.e. the Columns, the Rows and Volume structure using matrix visual). I am working on and trying to fix few things which i need.
Sure, I will post my questions for help.
Thank you.
Hi Anonymous
Need inputs on the below scenario,
I have added 2 rows related to Item3 with Volume value as Blank (or) Empty . Refer the last 2 rows in the below Table data.
Is there a way to display blank rows using a measure ?
Region Location Item Volume Region2 Location11 Item1 407 Region2 Location11 Item2 0 Region2 Location10 Item1 3 Region2 Location10 Item2 0 Region2 Location9 Item1 35 Region2 Location9 Item2 0 Region2 Location8 Item1 633 Region2 Location8 Item2 0 Region2 Location7 Item1 2881 Region2 Location6 Item1 217 Region2 Location6 Item2 1200 Region1 Location5 Item2 0 Region1 Location4 Item4 581 Region1 Location2 Item4 1270 Region1 Location1 Item4 358 Region1 Location3 Item3 Region2 Location9 Item3 Expected Visual:
Display Item3 as a blank row
Thanks.
Hi,
I have explored and Found solution to display the blank rows in the Matrix visual ( i.e. display the rows which has no values)
Refer the below post i submitted for more details (https://community.powerbi.com/t5/Desktop/Need-help-on-designing-Visual/m-p/561243#M264742)
Solution:
Rows --> select the Row field and right click and choose "Show items with no data" option.
Same applies to,
Columns --> select the Column field and right click and choose "Show items with no data" option.
Refer the below working visual:
Item5 has blank values but still the entire Item5 Row is displayed in the Matrix visual.