Forum Discussion

segato's avatar
segato
Helper I
4 years ago
Solved

Views or conditional data

I have imported data from application insigths. Now I would like show a graph only with data where Name  is "Q88VesselChecked". What is the right approach to do this? I guess it is making a new dataset like a view ? Or what tools do we have for this in Power BI?

 

 

4 Replies

  • segato , Create a visual and filter that using the slicer

     

    if you want new table

     

    calculatetable(Table, Table[Name] ="Q88VesselChecked")

    • segato's avatar
      segato
      Helper I

      Thanks appreciated  Can you ellaborate on making a new table based on the other? How do you do that from the Desktop?

    • segato's avatar
      segato
      Helper I

      Just tested the DAX part. Works like a charm. Appreciated!

  • segato there are many ways to do this, with DAX, click modelling -> new table and then write DAX statement:

     

    Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.