Forum Discussion

POWER_MI's avatar
POWER_MI
Post Patron
5 years ago

Help General Question

Hi  I have somes questions about Power BI I need to know for example when you will have KPI results on table  for example KPI row project  Red color 15 row on results  ...on the report of dashbo...
General Comment
Interesting Links
Need Help
Tips and Tricks
POWER_MI's avatar
POWER_MI
Post Patron
5 years ago

Hi Rico,

thanks a lot for answer.

The asking is for example in your table when you have KPI

USER : I

Value: 60

is it possible to example just the value 60 of this windows User I and value 60.

it's very special

thanks for help

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi POWER_MI 

My origanal Table is as below.

If you only want to see User =1 and Value = 60, you may use filter.

User column show values = I , Value column show values = 60.(If you have multipy USER = 60 and multipy Value =60)

Result:

If this reply still couldn't help you solve your problem, please show me more details about your data model and tell me the result you want. This may make it easier for me to understand.

 

Best Regards,

Rico Zhou

 

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

  • POWER_MI's avatar
    POWER_MI
    Post Patron
    5 years ago

    Hi Rico,

    thanks for your feeed back.

    the asking is not to export excel table of dashbord, the objectif is when you select the row :

    user : I

    value : 60

    when we will click on this 60 we will export the 60 Rows of KPI that not OK

    for example 60 rows we click on the case I60 and we will export all row 60

    for example for

    Row : D

    Value : 90

    we will export on excel file the 90 ligne you see

    because for our activité it's KPI means

    KPI

    PROJECT 1 25 (KO)

    PROJECT 2 15

    PROJECT 3 13

    PROJECT 4 28

    So to arrive to this table we will selection all values and see who have KO KPI and OK kpi

    in this case

    for example for Red KPI means KO Kpi when we will click on

    Row :project 2

    Values : 15

    in this case we will export 15 row on exce

    • POWER_MI's avatar
      POWER_MI
      Post Patron
      5 years ago

      Hi Rico,

      I have make here one example with Data

      you will find enclosed the file used to define project.

      the excel file is source

      excel_file_database_source.PNG

      On power BI this is dashboard

      Power_BI_Results.PNG

      this is mesure that y add on poweer BI

      Number of STATUS for OK
      CALCULATE(COUNTA('Tableau1'[STATUS]), 'Tableau1'[STATUS] IN { "OK" })
      the asking is when i will select for example box with Nombre de STATUS pour OK = 3 ( row "To do 1"/"OP1"/status "KO" ) i will export the 3 line of this box means the results 3
      are number but will also export this concerned rows 3 with excel rows not just number 3.
      results.PNG

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi POWER_MI 

        I try to export the table visual you show to me.

        However we can't export the values directly by the visual you show to me.

        I build a new table visual and filter it by the rows(Measure) you show to me. When I select 3 ( row "To do 1"/"OP1"/status "KO" ), visual2 will be filtered by Action and Status, so it shows the result: Status = KO.

        Even I select 3 ( row "To do 1"/"OP1"/status "OK" ), it will only show the aggregation result.(Only one row)

        Currently, you may not be able to export the result like your screenshot. 

        Power BI will aggregate the same rows and show one row in table visual.

        To achieve your goal, I add an index column in data model(Power Query Editor - Add column- index) and build a new table visual to filter visual 2.

        New Table:

        New visual：

        In this visual, select 3( row "To do 1"/"OP1"/status "OK" ) ,and export visual 2.

        We can't filter Status OK by select Status = KO in other visuals.

         

        Best Regards,

        Rico Zhou

         

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