Conditionnal color, calculated measure and Slicers interactivity in page

[HANA]

Hello,

I am new in Power BI and I have several questions in order to understand the behaviour of Power BI. Can you please help me ?

There is my issue :

A. This is my data

B. I have create one page like this

My questions :

B1 : How can I take off the term "infinity" and put noting instead ?

B2 : Can i put some conditional color in the cell by using matrix visualization ? I have noticed than it is possible in table ant not in matrix.

B3 : In my example (Visualization table), the conditional color is applied in each cell and not in the total row, how put the conditionnal color in the total row also ?

B4 : Can we put conditionnal color on the text and not the cell ?

C. I have create a second page by using the same query like this :

My question :

C1 : Can we put conditionnal form, color on graphics ? Example when data is <0, the color is red.

C2 : Can we link the slicers of Page 1 and Page 2 in order to fliters the same data.

Example when we filter in the page1 in the slicer Country=France. In page 2, the Slicer Country=France also.

Thank you in advance for your help

[Vvelarde · Accepted solution]

@HANA

hello.

B2, B3, B4, C2 in this moment is not possible.

B1:

Measure=Divide(sum(QuantityA),(QuantityB)),blank())

C1: yes is possible to do

put the data column in color saturation, net go to format and select the color and set minimum 0 and maximum 0. 

[Vvelarde · Accepted solution]

@HANA

hello.

B2, B3, B4, C2 in this moment is not possible.

B1:

Measure=Divide(sum(QuantityA),(QuantityB)),blank())

C1: yes is possible to do

put the data column in color saturation, net go to format and select the color and set minimum 0 and maximum 0. 

[HANA]

Thank you for answer.

I just want some precision about the question C2.

C2 : Can we link the slicers of Page 1 and Page 2 in order to filter on the same data.

Example when we filter in the page1 in the slicer Country=France. In page 2, the Slicer Country=France is automaticaly selected also.

Is there another way to do this fonctionnality ? I want that the user has the possibility to filter once and the filter is applied every where in the page. I do not want to use the box filter below the box visualisation because it is not very user friendly for some users.

Thank you.

[Sean · Accepted solution]

@HANA Yes you can achieve this result not with Slicers but by placing the Country field in the REPORT Level Filter!