Forum Discussion

Sandeep13's avatar
Sandeep13
Helper III
1 year ago
Solved

BAR Chart values not showing

Hi All,   I want to show number and Percentage in my bar chart. In below Bar chart you can see we have 2 category one is 0-7 and  >7 days which is in red colour number is visible only for consumer ...
  • lkalawski's avatar
    lkalawski
    1 year ago

    Hi Sandeep13 ,

     

    The only option I see now is to stack the charts.

    Below create a 100% stacked bar chart, disable the data label for >7 Days. Create a Line Chart that shows the Share values, invert the Y-axis so that 0% starts at the top. Disable everything possible (titles, values, background) and stack one on top of the other.
    You can also disable interactions between them, and also group the two visualizations and enable maintain layer order so that no one changes the visualization order.

     

    Memorable Member | Former Super User
    If I helped, please accept the solution and give kudos! 
    Linkedin

     

  • Sandeep13's avatar
    Sandeep13
    1 year ago

    Hi lkalawski Thanks for your idea.

     

    Request you to please share PBIX file for  reference.

     

    Hi lkalawski  Pleae share me .pbix file so I can take it as a refrence for my other Tile and reports. Thanks in advance.

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi lkalawski ,thanks for the quick reply, I'll add more.

    Hi Sandeep13 ,

    When I finished my testing, I found that the problem was solved, but I still wanted to share my solution.

    1.Disabled data labels older than 7 days

    2.Create a line chart and create the following measures

     

    Measure1 = CALCULATE(SUM('Table'[Count of Member_File_Name]),'Table'[LOAD_TAT_Category] = ">7 Days") 
    Measure2 = 
    VAR _result = CALCULATE(SUM('Table'[Count of Member_File_Name]),'Table'[LOAD_TAT_Category] = ">7 Days") 
    
    RETURN _result & UNICHAR(10) & FORMAT(DIVIDE(_result,SUM('Table'[Count of Member_File_Name])),"0.00%")

     

    3.Adjust the position of the line chart and place it at the top.

     

    Best Regards,
    Wenbin Zhou