Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
1. Need help on designing visual.
2. If there is no Item value for any of the locations, then display blank. Refer the ItemVolumeByRegion Visual.
Ex: Item3 has no value for any of the locations in two Regions (Refer ItemVolumeByRegion Table Data), so it is displayed as blank.
3. Region 1 title font color as custom color --> #000000, background color as custom color --> #DA9694
4. Region 2 title font color as custom color --> #000000, background color as custom color --> #C4D79B
Attached is the expected ItemVolumeByRegion Visual screenshot & ItemVolumeByRegion table data below for reference.
ItemVolumeByRegion Visual
ItemVolumeByRegion Table Data
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 |
Thank you.
Solved! Go to Solution.
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
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
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.
Hi @Anonymous
can you please share the PBI file for the below example you shared initially in your first post.
Thanks.
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.
Thank you for sharing the PBI file.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |