All geek questions in one place

Show different data types in the same visualization in Power BI

I have a scenario where I have a column in a table that has multiple project lists. And each project has a different type. And the types for ex FP and T & M. Now, as we see in the first image, the charge coefficient is displayed for projects like FP and the second image showing the use of the Bill for T & M projectsNow, as we see in the first image, the charge coefficient is displayed for projects like FP.

. and the second image showing the use of the Bill for T & M projects> </a> </p> <p> My requirements: I want to show both the charge coefficient and the use of the beat in one visual correspondence with the type of project. I have a slicer that the user can select projects. If the selected project is of type T & M, then it should display visual information in accordance with this type. If it is FP, then only in this line chart, I would like to show visual images in accordance with this type. </P> <p> Note. - I do not want to use slicer to select TYPE </p> <p> Please give me a suggestion. </p> <p> Thank you .</p></div></body> </html>

+4
source share
2 answers

You can display both the charge coefficient and the use of the account in one form.

A simple solution

Project 2 : . - , . , , . , , : .

FP, T & M, , , , , , . .

Ratio =
IF (
  RELATED ( 'Project'[Project Type] ) = "FP",
  [Charge Ratio],
  [Bill Utilization]
)

"title":

Ratio Name =
IF (
    RELATED ( 'Project'[Project Type] ) = "FP",
    "Charge Ratio By Month (FP)",
    "Bill Utilization By Month (T&M)"
)

, (, ):

Ratio Name Measure =
IF (
    HASONEVALUE ( 'Ratios'[Ratio Name] ),
    MAX ( 'Ratios'[Ratio Name] ),
    "Charge Ratio & Bill Utilization By Month"
)

, : Line chart and slicer with two selected projects

0

, , .

. , "".

. , . , . . , . .

"" , .

, , , . FP T & M, T & M FP.

0

Source: https://habr.com/ru/post/1677325/

More articles:


All Articles