Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Combining 2 Columns together into single axis on a Column Chart

Hello,

 

I'm working with some data creating by simulating some numbers, and having trouble creating visuals around them.

 

I have two datasets: One of which shows current numbers (as of now). Another, which is a consolidation of numbers from different scenario runs run in the past)

 

For Example:

Dataset #1: 

 

CustomerIDBase Rating
123RT1
456RT2
789RT2

 

Dataset #2:

CustomerIDBase RatingRating_Following_SimulationScenario
123RT3RT9Scenario1
456RT5RT6Scenario1
789RT9RT10Scenario1
123RT10RT10Scenario2
456RT1RT3Scenario2
789RT4RT2Scenario2

 

Effectively, Base Rating and Rating_Following_Simulation run on the same type of Ratin System.

I have Appended the two datasets so that they currently look like this:

 

CustomerIDBase RatingRating_Following_SimulationScenario
123RT1 Baseline
456RT2 Baseline
789RT2 Baseline
123RT3RT9Scenario1
456RT5RT6Scenario1
789RT9RT10Scenario1
123RT10RT10Scenario2
456RT1RT3Scenario2
789RT4RT2Scenario2

 

Is there any for me to create a Column Chart, whereby the Base Rating and Rating Following Simulation can be combined and be shown in the same X-AXIS, without having to utlise drilldown? This way, a user can look at the rating and compare the rating as it currently is (baseline), and against the base rating when Scenario 1 was run, and then against the updated rating following Scenario 1 being run?

 

I want to then use Customer ID as the Y-AXIS to effectively Count Distinct how many Customer IDs fall into each of the Rating baskets.

 

Unsure on how to approach this. Would it be easier to Join? Or continue to Union the datasets?

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak 

      Essentially, I have the #1 Dataset which is refreshed daily, and #2 Dataset which is built off the first dataset but based on simulations done to "shock" or "stress" the ratings. These shocks or stress, you can imagine them as a way of testing for extreme financial situations as an example. These ratings determine how much each customer would receive as an example. The

       

      Now the results of #1 Dataset show the Base Rating as it is today (as it is refreshed daily).

      Now the results off #2 Dataset show the Base Rating as it was when the simulations were run at the moment scenarios #1 and scenario #2 were run, and then after scenarios wer run - there new ratings.

       

      I want to create a column chart which shows something similar to this - but Orange Bar would for example represent only the Base Rating from Dataset 1, and Dataset 2 would be represented on the Light Blue / Dark Blue as both the "Base Rating" for Scenario 1 and "Rating following Simulation".

       

      X-Asis would me something like: RT 1, RT 2, RT3 etc. 

       

       

      By extension, I'm hoping to build off a Slicer which allows me to change between scenarios 1 and 2 for the light and dark blue.

       

      • v-lionel-msft's avatar
        v-lionel-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        You need to append these two tables together.

        At last, you will get a table like this.

        And Create a measure like this.

        Measure = 
CALCULATE(
    DISTINCTCOUNT(Append2[CustomerID]),
    ALLEXCEPT(Append2, Append2[Rating1] )
)

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.