Forum Discussion

amikm's avatar
amikm
Icon for Helper V rankHelper V
5 years ago
Solved

Issue with DAX Calculate and Filter

Hi,   I am trying to create a KPI (stacked bar chart)  to show the count of Products sold between Jan 21, Feb 21, March 21 and products sold between April 21, May 21, June 21.   The scenari...
Need Help
  • amikm's avatar
    amikm
    Icon for Helper V rankHelper V
    5 years ago

    Hi V-lianl-msft ,

     

    Your solution looks perfect, but I only have a challenge with Visualisation,

    I want to create a stacked bar chart like this (right-hand side), In the left-hand side visual is fine but instead of showing into two different bars, it shows in one. (stacked bar chart)

    Note: Right-hand side is just for example based on the existing PBIX file, where I took, both the R1-R3 measure and R4-R7 measure in a stacked bar chart value bucket. I want count

     


      • amikm's avatar
        amikm
        Icon for Helper V rankHelper V
        5 years ago

        Hi V-lianl-msft ,

         

        I missed one requirement for the same KPI, where I need to display the Sales as well.

         

        But when I tried to add this functionality to this report, it is not displaying the Sales as expected on hovering on Measure 3 and Measure 4

        Screenshot 1:


        Screenshot 2:


        It should show one at a time on hovering means when I hover over Measure3 it should show count and sale for R1-R3 and when I hover over Measure 4 it should show count and sale for R3-R6.

         

        Thanks