Forum Discussion

PBIBeginner2022's avatar
PBIBeginner2022
Helper III
4 years ago

Array with three entry/input visual Power BI Desktop

Hi,

 

 

I would create on Power BI Desktop an array with three input/entry :

 

  • 2 input in line
  • 1 input in column

 

First input is my extraction date of my order in month.

Second input in line is my order type.

In put in column is all month of the current year.

 

Please find attached an overview of what I want to achieve : 

 

 

 

Thanks in advance

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi PBIBeginner2022 ,

     

    Based on your description, my suggestion is that you can create this array in excel and then connect to this data source in powerbi desktop. When you click refresh, it will update the latest data in the excel table. powerbi desktop is not the best tool for entering data directly.


    If the problem is still not resolved, please point it out. Looking forward to your reply.


    Best Regards,
    Henry


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

    • PBIBeginner2022's avatar
      PBIBeginner2022
      Helper III
      4 years ago

      Thanks v-henryk-mstf 

       

      However, this didn't solve my problem. I want a visual like the photo I attached in my first message with into this array the data of my tables in Power BI.