Forum Discussion

Mezga's avatar
Mezga
Icon for Helper I rankHelper I
4 years ago

Play Axis and Visio - Colour Animating

Hello,

 

I'm trying to get a Visio visual to work with the custom visual "Play Axis". 

 

The Visio visual is basically just a bunch of shapes on a map (representing the fabrication status of a building). These are linked in Visio to the same data source as Power BI is using. Each shape has a unique ID that is correctly mapped in Visio and Power BI.

 

For the duration of a project, the fabrication status of each building will change each month. In my data source, I have a column for month 1 to 50 of the project. Each building has its own row, and its status in each month is simply a number between 1 to 10.

 

On the Visio visual in Power BI, the "ID" is a column with all the building names, and the "Values" is a measure I have created as per below:

 

 

 

BUILDING STATUS = 
SUMX(
    'TIMELINE',
            SWITCH(
                'TIMELINE'[MONTH NUMBER],
                1,SELECTEDVALUE('MODULE LIST'[MONTH 1]),
                2,SELECTEDVALUE('MODULE LIST'[MONTH 2]),
                3,SELECTEDVALUE('MODULE LIST'[MONTH 3]),
                // and so on to month 50

 

 

Where [MONTH NUMBER] is a table with month 1 to 50 in one column.

 

On the Visio visual, I then colour code "BUILDING STATUS", for each values from 1 to 10 (i.e. 1 to 1, 2 to 2, 3 to 3, etc until 10 to 10).

 

I then inserted a standard slicer, and assigned [MONTH NUMBER] to it. When selecting a single month, the shapes are correctly coloured.

 

What I am now trying to do is use a Play Axis visual to cycle through [MONTH NUMBER] from 1 to 50, and the shape colours will update automatically.  However I just can't get it to correctly filter the Visio visual when I do this. Depending on what I do it either:

 

1. Just hangs on the current selection from the standard slicer, or;

2. Cycles through the months correctly, but all the shapes remain blank.

 

I've read numerous other threads such as this one, but it doesn't seem to work.

 

Any ideas would be greatly appreciated.

 

 

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support

    Hi,  Mezga 

    You can refer to this related tutorial.

    Power BI and Visio: What if they are better together 

    Please check whether your measure is correct.(I have questions about the code of the 'switch' part added in your measure)

    Then make sure that you have specified the  measure for the Values property in the Visio diagram.

     

    Best Regards,
    Community Support Team _ Eason