Forum Discussion

nish18_1990's avatar
nish18_1990
Helper III
1 year ago
Solved

Custom Visual

Is it possible to create a visual something like below in Power BI .   Red Line is country China Blue line for India Dark blue for Poland    The numbers are for 5 categories which are plotted a...
Need Help
  • v-lgarikapat's avatar
    v-lgarikapat
    11 months ago

     Hi nish18_1990 ,

    Thanks for the follow-up question. Below is a workaround

    Stacked Area Chart with Transparent Layers

    If you prefer native visuals

    • Create a stacked area chart with transparent fills.
    • Use conditional formatting or layered shapes to simulate background color bands.
    • You’ll need to pre-process the RAG status into a separate layer or use bookmarks/shapes creatively.

    Limitations

    • Harder to control background shading per category.
    • Axis orientation may be less intuitive.

    Apply Conditional Table Formatting in Power BI - Power BI | Microsoft Learn

    Best Regards,

    Lakshmi .

     

nish18_1990's avatar
nish18_1990
Helper III
1 year ago

Hi,

 

Please find data sample :

 

CategorycountryKRIColor
FurnitureChina1.4Green
MobilesChina2Green
AutomobileChina4Amber
AutomobileIndia1Green
MobilesIndia6Red
FurnitureIndia3Green
AutomobilePoland2Green
MobilesPoland5Amber
FurniturePoland2Green
v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi nish18_1990 ,

 

Apologies for the delayed response.

I've uploaded the sample PBIX file  The current approach is working to some extent, but it's still more of a workaround rather than a complete solution.

Could you please take a look and share your feedback?

Best regards,
Lakshmi

 

  • v-lgarikapat's avatar
    v-lgarikapat
    Community Support
    1 year ago

    Hi nish18_1990 ,

    I wanted to follow up and confirm whether you’ve had the opportunity to review the information we provided. If you have any questions or need further clarification, please don’t hesitate to reach out.

     

    Best Regards,

    Lakshmi

    • v-lgarikapat's avatar
      v-lgarikapat
      Community Support
      1 year ago

      Hi nish18_1990 ,

      We haven’t heard back from you regarding our last response, so I just wanted to check in to see if you were able to resolve the issue. If you have any further questions or need assistance, please feel free to let us know.

       

      Best Regards,

      Lakshmi

  • nish18_1990's avatar
    nish18_1990
    Helper III
    11 months ago

    Can we achieve something like the visual i shared . The range should be against the category . The category in the image is in left hand side and the numbers are plotted against the category based on the colors and the background colors

    • v-lgarikapat's avatar
      v-lgarikapat
      Community Support
      11 months ago

       Hi nish18_1990 ,

      Thanks for the follow-up question. Below is a workaround

      Stacked Area Chart with Transparent Layers

      If you prefer native visuals

      • Create a stacked area chart with transparent fills.
      • Use conditional formatting or layered shapes to simulate background color bands.
      • You’ll need to pre-process the RAG status into a separate layer or use bookmarks/shapes creatively.

      Limitations

      • Harder to control background shading per category.
      • Axis orientation may be less intuitive.

      Apply Conditional Table Formatting in Power BI - Power BI | Microsoft Learn

      Best Regards,

      Lakshmi .